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

Read More

In this article, I'll explain what formatting SQL is, and how to find the SQL Developer Format SQL options.

Read More

In this article, I'll explain what the SQL Developer Autocommit feature is, where to find it, and how to turn it on or off.

Read More

In this article, I'll show you what line numbers are in SQL Developer and how to turn this setting on.

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

When using Oracle SQL, there are many ways to convert data types. Three of the most common data types are string (VARCHAR2), number, and date. Let's take a look at how you can convert to these types.

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