Sql-Functions

There are several functions in SQL, such as NVL and ISNULL, that perform some kind of logic on the values that are provided. Learn what they all do and see some examples in this article.

SQL MOD and REMAINDER Function Guide, FAQ, and Examples

Dec 31, 2017 · 7 min read · sql-functions ·

Share on:

The SQL MOD and REMAINDER functions are very similar and are useful for working with numbers and even for other operations. Learn what they are, and the differences, in this article.

Oracle Variance Functions Guide, FAQ, and Examples

Dec 26, 2017 · 12 min read · sql-functions ·

Share on:

In this article, we’ll look at a range of Variance functions, explain what they do, and see some examples.

Oracle Timezone Functions Guide, FAQ, and Examples

Dec 24, 2017 · 9 min read · sql-functions ·

Share on:

In this article, we’ll look at the FROM_TZ, TZ_OFFSET, TO_TIMESTAMP_TZ, and NEW_TIME functions in Oracle, explain how they work, and see some examples.

SQL LENGTH/LEN Function Guide, FAQ, and Examples

Dec 24, 2017 · 6 min read · sql-functions ·

Share on:

In this article, we’ll look at the LENGTH function and its variants, and the VSIZE function, explain how they work, and see some examples.