In this article, we’ll look at the different LOB functions available in Oracle, learn what they do, and see some examples.
There are several functions in Oracle, such as NVL and NVL2, that perform some kind of logic on the values that are provided. Learn what they all do and see some examples in this article.
The Oracle 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.
In this article, we’ll look at a range of Variance functions (VARIANCE, CUME_DIST, CORR, VAR_POP, COVAR_POP, VAR_SAMP, and COVAR_SAMP), explain what they do, and see some examples.
Calculating the mean, median, and mode in Oracle SQL is a task often performed by report developers or anyone else working with SQL. Learn how to calculate these three values from a range of data in this article.
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.
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.
The Oracle CHR, ASCII, NCHR, and ASCIISTR functions are useful when translating between text characters and their ASCII codes. Learn all about these functions in this article.
In this article, we’ll look at the INSTR function (including its variants), explain how to use it, and see some examples.
The Oracle GREATEST function and LEAST function are quite useful, but not very well understood. Let’s take a look at these functions and see some examples in this article.