FB
Oracle LOB Functions FAQ, Guide, and Examples

Oracle LOB Functions FAQ, Guide, and Examples

In this article, we’ll look at the different LOB functions available in Oracle, learn what they do, and see some examples. Purpose of the Oracle LOB Functions There are a few LOB-related functions in Oracle. What are they all for? TO_CLOB The TO_CLOB function converts... Read more
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 the... Read more