Oracle triggers are a handy but often misused function of the Oracle database. Learn all about them in this article.

Read More

Have you seen ROWNUM and ROW_NUMBER in Oracle and wondered what the difference is? Learn what they are and the differences between Oracle ROWNUM vs Oracle ROW_NUMBER in this article.

Read More

The Oracle TO_DATE function is one of the most common and useful string manipulation functions in Oracle, but it can be confusing. I'll explain how to use the TO_DATE function in this article.

Read More

In this article, I explain what the different data types are in Oracle database and everything you need to know about them.

Read More

This article will answer some of the common questions, and questions I had about Oracle character sets and how they relate to the Oracle database.

Read More

The Oracle BFILENAME function is a useful file manipulation function. Learn what it is and how to use it in this article.

Read More

Oracle 12c is Oracle's latest version of its database engine. Learn about all of the new Oracle 12c new features for developers in this massive guide.

Read More

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 tried to run a query and got the "ORA-00979 not a group by expression" error? Learn what it is and how to resolve the error in this article.

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