One of the most valuable features for writing SQL queries is seeing how long it will take to run and how efficient it is. In SQL Developer, there's an option called "Explain Plan". Let's see how that works.

Read More

In the world of software development, we use and see a lot of acronyms. In this article, I've listed a lot of common acronyms, along with definitions, which can help your understanding in the workplace.

Read More

In this article, I'll explain what the DBMS_OUTPUT function is and how it works in SQL Developer.

Read More

Oracle's SQL Developer tool lets you export a list of connections that you have created. This is great for saving time for your team. Learn how you can do that 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

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