In this article, I’ll show you what the ASCII function is and demonstrate some examples. Purpose of the Oracle ASCII Function The ASCII function is used to convert a single character into a number that represents the character. It’s how you get an ASCII value of a CHAR in Oracle. MORE

The Oracle NANVL function is useful when working with number values. Learn what it does and how to use it in this article. Purpose of the Oracle NANVL Function The NANVL function is used to return a different value if the specified value is NaN (not a number). MORE

Data Visualization Examples. In this post, I will share some examples of Discovery, Quality, and Dashboard Visualizations. There are too many good examples of Trends/Predicative and Storytelling Dashboards and it was too hard to select one for this post. MORE

In this article, I’ll explain what the Oracle VSIZE function does and show you some examples. Purpose of the Oracle VSIZE Function The VSIZE function returns the number of bytes of an expression using the internal representation. MORE

In this article, I’ll explain what the Oracle EMPTY_BLOB function does and show you an example of how to use it. Purpose of the Oracle EMPTY_BLOB Function The EMPTY_BLOB function is used to initalise a LOB column to EMPTY. MORE

String concatenation is the process of joining two string values together. Let’s see how to do it in several different databases. What is String Concatenation in SQL? The definition of concatenate means to join two things together. MORE

In this article, I’ll explain what the Oracle VARIANCE function is, and show you some examples. Purpose of the Oracle VARIANCE Function The purpose of the VARIANCE function is to, well, return the variance of a set of numbers. MORE

In this article, I’ll explain what the NEW_TIME function does and show you some examples. Purpose of the Oracle NEW_TIME Function The NEW_TIME function converts a date from one timezone to another timezone. MORE

Nowadays, we see people opening websites and search through hundreds of pages for a certain one. The websites come in all shapes and sizes and are viewed across the different devices varying from desktop computers and laptops to smartphones. Sometimes, it can be a serious challenge to develop websites assuming all these options MORE

UK startups focused on technology for insurance companies saw capital investments double last year MORE

In this article, you’ll learn what the WHERE clause is in SQL, how to use it, and see some examples. Description The SQL WHERE clause allows you to filter the results used in your query. It lets you specify the rows that will be used. MORE

The post THREE UNUSUAL EXAMPLES OF INDUSTRY INTEGRATION IN BLOCKCHAIN appeared first on Dataconomy. How a bunch of tech savvy entrepreneurs are using blockchain to solve problems in the areas of graphics rendering, identification processes and diamond trade. MORE

In this article, I’ll explain what the Oracle COMPOSE function is and show you some examples. Purpose of the Oracle COMPOSE Function The COMPOSE function allows you to provide a string or a string expression, and return a Unicode string of that input. MORE

In this article, I’ll explain what the Oracle LN function is, and show you some examples. Purpose of the Oracle LN Function The purpose of the Oracle LN function is to calculate the natural logarithm of a number. MORE

Here are some of those examples although you should read the entire article to gain more context: Currency: OK, they don’t go into much detail but it’s the main use case EVERYONE uses. IBM uses an example of tracking a diamond through it’s lifecycle. MORE

For example, […]. The DECOMPOSE function is a handy string manipulation function. Learn more about it and find out what it does in this article. Purpose of the Oracle DECOMPOSE Function The DECOMPOSE function is used to transform a string into a Unicode string. MORE

In this article, we look at the Oracle COS function and see some examples. Purpose of the Oracle COS Function The COS function will return the cosine of a number. If your knowledge of cosine is a bit rusty (like mine), then you might find this definition helpful. MORE

In this article, I’ll explain the Oracle SQRT function and show you some examples. Purpose of the Oracle SQRT Function The purpose of the Oracle SQRT function is to find and return the square root of a provided number. MORE

In this article, I’ll explain the Oracle TAN function, what it is, and show you some examples. Purpose of the Oracle TAN Function The purpose of the Oracle TAN function is to calculate the tangent of a number. MORE

Information Technology Blog - - Examples of Great Experimental Marketing Campaigns - Information Technology Blog. Great example of Storytelling. The post Examples of Great Experimental Marketing Campaigns appeared first on Information Technology Blog. MORE

The global WannaCry and NotPetya attacks were both examples of pseudo-ransomware, according to McAfee researchers MORE

Learn what it does and see some examples in this article. The Oracle INITCAP function is a handy string manipulation function. MORE

In this article, I’ll explain what the Oracle NCHR function is and show some examples. Purpose of the Oracle NCHR Function The NCHR function returns a character based on the specified number code in the national character set. MORE

Learn how to use it and see some examples in this article. The Oracle HEXTORAW function is a basic conversion function used in Oracle SQL. Purpose of the Oracle HEXTORAW Function The purpose of the HEXTORAW function is to convert a hexadecimal value into a raw value. MORE

We often read anecdotal evidence of how companies and consultants are using big data to solve ‘big’ problems but it is rare that we see real world examples of the use of analytics and data to solve real-world business problems for small and midsized businesses. MORE

Learn how to use it and see a range of examples in this guide. The SQL Server DATEDIFF function lets you find the difference between two dates in a range of different units. MORE

Learn how to use it and see some examples in this article. The Oracle TO_SINGLE_BYTE function is useful for databases with different character sets. MORE

Yesterday I wrote Separate then Solve: a model for solving problems to explain how I tackle really knotty problems. People tell me that they like how I manage this kind of challenge - especially in team situations where there are lots of stakeholders. MORE

In this article, I’ll explain how to use the Oracle BITAND function and show you some examples. Purpose of the Oracle BITAND Function The Oracle BITAND function is used to perform what’s called a standard bitwise AND operation. MORE

In this article, I’ll explain what the STDDEV function does and show you some examples. Have you ever seen the Oracle STDDEV function? Purpose of the Oracle STDDEV Function The purpose of the STDDEV function is to find the standard deviation of a set of numbers. MORE

All the world’s tech giants from Alibaba to Amazon are in a race to become the world’s leaders in artificial intelligence (AI). These companies are AI trailblazers and embrace AI to provide next-level products and services. MORE

In this article, I’ll explain what the Oracle MEDIAN function is, and show you some examples. So, for example, you had these five values: 10, 15, […]. Purpose of the Oracle MEDIAN Function The MEDIAN function returns the median of the set of provided values. MORE

In this article, I’ll explain what the Oracle SIN function is and show you some examples. Purpose of the Oracle SIN Function The purpose of the SIN function is to calculate the sine of a number. MORE

In this article, I’ll explain what the Oracle LNNVL function does and show you some examples. Purpose of the Oracle LNNVL Function The purpose of the LNNVL is to perform a “logical not null” on the expression that has been provided. MORE

In this article, I’ll explain what the Oracle SESSIONTIMEZONE function is, and show you some examples. Purpose of the Oracle SESSIONTIMEZONE Function The SESSIONTIMEZONE function returns the timezone offset of your session, in the format of [+|-]TZH:TZM, or a time zone region name. MORE

In this article, I’ll explain what the Oracle CHARTOROWID function is and show you an example. Purpose of the Oracle CHARTOROWID Function The purpose of the CHARTOROWID function is to convert a value from a several character data types into a ROWID data type. MORE