The Oracle CONVERT function doesn't do what you might expect it do, if you just look at its name. Learn what this function does and how to use it in this article.

Read More

The Oracle TRANSLATE function is a similar function to REPLACE, but it has a few differences. Learn what the differences are and see some examples in this article.

Read More

In this article, you'll learn everything about the SQL RANK and DENSE_RANK functions that are available in Oracle, SQL Server, MySQL, and Postgres.

Read More

The Oracle TO_TIMESTAMP function is useful if you need to work with timestamp data types. Learn how to use it with some examples in this article.

Read More

In this article, I'll explain how the very useful ADD_MONTHS function works and use some examples.

Read More

The SQL NULLIF function is available in many vendors. Let's take a look at what NULLIF does and what you can use it for.

Read More

The Oracle SUBSTR function is used to get a smaller string (the substring) from within a larger string. Let's take a look at how you can use it and some examples.

Read More

This article explains the Oracle LISTAGG functions, which is one of the more difficult functions to understand. Purpose of the Oracle LISTAGG Function The purpose of the Oracle LISTAGG function is to allow you to perform aggregation of strings from data in columns. What is string aggregation? Well, it's a technique …

Read More

Learn about the SQL COALESCE function in this guide.

Read More

The SQL ROUND function allows you to round a number to a specific number of decimal places. Let's see how it works and see some examples.

Read More