If you've used MySQL, you're probably familiar with the AUTO_INCREMENT feature. But it's not available in Oracle. Read this article to find out how you can auto increment a column in Oracle SQL.

Read More

Have you seen SQL statements with the word DUAL in them? Wondering what it is? Find out what the dual table in Oracle is in this article.

Read More

In this article, I'll show you how you can limit the number of rows in Oracle SQL.

Read More

A common question in Oracle SQL, and SQL in general, is to select rows that match a maximum value for a column. Let's see how you can do that in SQL.

Read More

Learn how to use the SQL Developer debug feature.

Read More

In this article, I'll explain how you can use the SQL Developer export functionality.

Read More

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 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 what formatting SQL is, and how to find the SQL Developer Format SQL options.

Read More