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
I’ll explain how to use it in this article and show you some examples. The Oracle AVG function is a common function in Oracle SQL. Purpose of the Oracle AVG Function The AVG function calculates the average of a series of values that you provide to it. 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
Recorded Future has just posted another nice piece of analysis on the cyber threat. This one in particular deals with interesting patterns which can be observed in hacker forums. Summary of the analysis: Forums can be analyzed at traffic level, without an analyst knowing foreign languages or tracking individual posts. Analysts can detect patterns in timing, forum participant product and vulnerability, etc. and use this knowledge to determine whether forum participants are a threat. 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, we’ll look at the variations of the Oracle LENGTH function – LENGTH2, LENGTH4, LENGTHB, and LENGTHC. 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
Examples of Two-Factor Authentication. Some of the most common examples of two-factor authentication include: Banks – Most banks now have two-factor authentication available to their customers. The examples above represent just a small sample of the organizations and companies that now offer or require two-factor authentication. The post Examples of Two-Factor Authentication & Why They Matter appeared first on Information Technology Group. MORE
In this article, I’ll take a look at the Oracle LOWER function, explain how it works, and see some examples. Purpose of the Oracle LOWER Function The LOWER function converts all letters within the specified string to lower case. MORE
In this article, I’ll explain how to use it and show you some examples. The NEXT_DAY function is a handy date manipulation function provided by Oracle. MORE
UK startups focused on technology for insurance companies saw capital investments double last year MORE
Learn how to use this function and see some examples in this article. The Oracle TZ_OFFSET function is a useful datetime function. 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
The Oracle BFILENAME function is a useful file manipulation function. Learn what it is and how to use it in this article. Purpose of the Oracle BFILENAME Function The BFILENAME function returns an object called a “BFILE locator” from a specified directory and filename. MORE
In this article, I’ll be covering the Oracle TO_MULTI_BYTE function, and look at some examples. Purpose of the Oracle TO_MULTI_BYTE Function The TO_MULTI_BYTE function is used to convert a character string from single-byte characters to multi-byte characters. MORE
web-app-case-study example SQL web appAs part of my web app, I needed to create a pivot-table style output for my reports. I’ll explain what the requirements were and what my solution was in this article. What Did I Need To Do? For the web app, I needed to output a table of data. 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
In this article, I explain what the GROUP_ID function does and show you some examples. Purpose of the Oracle GROUP_ID Function The GROUP_ID function is used to assign a number to each group that results from a SELECT query clause with a GROUP BY clause. 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 COVAR_SAMP function does and show you some examples. Purpose of the Oracle COVAR_SAMP Function This function returns the covariance of a set of number pairs. What does that mean? Here’s an explanation of what a covariance is. MORE
In this article, I’ll explain what the COVAR_POP function does and show you some examples. Purpose of the Oracle COVAR_POP Function The Oracle COVAR_POP function calculates the population covariance of a set of number pairs. What is a “population covariance”? Good question. 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
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
In this article, I’ll cover what the Oracle SINH, COSH, and TANH functions are, and show you some examples. 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
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
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 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 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
Examples Related Topics Complete IT Professional
DECEMBER 15, 2016
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.
CTOvision
SEPTEMBER 24, 2015
Recorded Future has just posted another nice piece of analysis on the cyber threat. This one in particular deals with interesting patterns which can be observed in hacker forums. Summary of the analysis: Forums can be analyzed at traffic level, without an analyst knowing foreign languages or tracking individual posts. Analysts can detect patterns in timing, forum participant product and vulnerability, etc. and use this knowledge to determine whether forum participants are a threat.
Complete IT Professional
JANUARY 6, 2017
In this article, I’ll explain what the Oracle COVAR_SAMP function does and show you some examples. Purpose of the Oracle COVAR_SAMP Function This function returns the covariance of a set of number pairs. What does that mean? Here’s an explanation of what a covariance is.
Complete IT Professional
SEPTEMBER 8, 2016
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.
Social, Agile and Transformation
APRIL 29, 2013
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.
Complete IT Professional
OCTOBER 27, 2016
In this article, I explain what the GROUP_ID function does and show you some examples. Purpose of the Oracle GROUP_ID Function The GROUP_ID function is used to assign a number to each group that results from a SELECT query clause with a GROUP BY clause.
Complete IT Professional
DECEMBER 23, 2016
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.
Complete IT Professional
JULY 7, 2016
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.
Complete IT Professional
JANUARY 5, 2017
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.
Complete IT Professional
JULY 21, 2016
Learn what it does and see some examples in this article. The Oracle INITCAP function is a handy string manipulation function.
Complete IT Professional
MAY 19, 2016
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.
Complete IT Professional
JULY 20, 2016
In this article, I’ll take a look at the Oracle LOWER function, explain how it works, and see some examples. Purpose of the Oracle LOWER Function The LOWER function converts all letters within the specified string to lower case.
Complete IT Professional
DECEMBER 16, 2016
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.
Complete IT Professional
DECEMBER 2, 2016
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.
IT Toolbox
MAY 24, 2017
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
Complete IT Professional
AUGUST 11, 2016
The Oracle BFILENAME function is a useful file manipulation function. Learn what it is and how to use it in this article. Purpose of the Oracle BFILENAME Function The BFILENAME function returns an object called a “BFILE locator” from a specified directory and filename.
Complete IT Professional
SEPTEMBER 29, 2016
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.
Complete IT Professional
DECEMBER 30, 2016
Complete IT Professional
DECEMBER 22, 2016
In this article, I’ll cover what the Oracle SINH, COSH, and TANH functions are, and show you some examples.
Complete IT Professional
DECEMBER 8, 2016
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.
Complete IT Professional
DECEMBER 1, 2016
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.
Complete IT Professional
DECEMBER 9, 2016
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.
Complete IT Professional
NOVEMBER 24, 2016
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.
Complete IT Professional
SEPTEMBER 28, 2016
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.
Complete IT Professional
MAY 12, 2016
I’ll explain how to use it in this article and show you some examples. The Oracle AVG function is a common function in Oracle SQL. Purpose of the Oracle AVG Function The AVG function calculates the average of a series of values that you provide to it.
Complete IT Professional
MAY 5, 2016
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.
Computer Weekly
MARCH 30, 2017
UK startups focused on technology for insurance companies saw capital investments double last year
Complete IT Professional
JULY 27, 2016
Learn how to use this function and see some examples in this article. The Oracle TZ_OFFSET function is a useful datetime function.
Complete IT Professional
DECEMBER 29, 2016
In this article, we’ll look at the variations of the Oracle LENGTH function – LENGTH2, LENGTH4, LENGTHB, and LENGTHC.
Complete IT Professional
JUNE 2, 2016
In this article, I’ll explain how to use it and show you some examples. The NEXT_DAY function is a handy date manipulation function provided by Oracle.
Complete IT Professional
OCTOBER 31, 2016
web-app-case-study example SQL web appAs part of my web app, I needed to create a pivot-table style output for my reports. I’ll explain what the requirements were and what my solution was in this article. What Did I Need To Do? For the web app, I needed to output a table of data.
ITGCT
MARCH 27, 2017
Examples of Two-Factor Authentication. Some of the most common examples of two-factor authentication include: Banks – Most banks now have two-factor authentication available to their customers. The examples above represent just a small sample of the organizations and companies that now offer or require two-factor authentication. The post Examples of Two-Factor Authentication & Why They Matter appeared first on Information Technology Group.
Complete IT Professional
SEPTEMBER 15, 2016
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.
INDUSTRY INSIGHTS YOUR PEERS ARE READING
8 
Let's personalize your content