FB
Oracle REMAINDER and MOD Function Guide, FAQ, and Examples

Oracle REMAINDER and MOD Function Guide, FAQ, and Examples

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. Purpose of the Oracle REMAINDER and MOD Functions Oracle REMAINDER Function The... Read more
Oracle Variance Functions Guide, FAQ, and Examples

Oracle Variance Functions Guide, FAQ, and Examples

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. These functions can be used as an analytic function or an aggregate function. I’ll... Read more
Oracle Timezone Functions Guide, FAQ, and Examples

Oracle Timezone Functions Guide, FAQ, and Examples

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. There are several timezone-related functions in Oracle, which I have described in this article.   Purpose of... Read more
Oracle LENGTH and VSIZE Functions Guide, FAQ, and Examples

Oracle LENGTH and VSIZE Functions Guide, FAQ, and 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. Purpose of the Oracle LENGTH Function The Oracle LENGTH function will find the length of, or the number of characters in, a... Read more