In the world of database, Oracle has long been recognized as a powerhouse. It offers a wide range of features and capabilities that make it a preferred choice for many organizations. One aspect that has often set Oracle apart from other databases are SQL features. In a recent update, Oracle Database 23c has introduced a new set of SQL enhancements making commands more intuitive and easier to use for developers.  In this briefing, we will cover the Oracle Database 23c SQL enhancements including the following:

Boolean Data Type

The Boolean data type in Oracle Database 23c offers a more intuitive and expressive way storing and manipulating logical values.

Select without From Dual

In Oracle, the “FROM DUAL” clause is typically used in queries when a table reference is required but no actual table is needed. To align with industry standards and enhance the user experience, Oracle has introduced a feature that removes the need for the “FROM DUAL” clause in certain scenarios. 

Schema-level Privileges

With Schema-level Privileges you now have the ability to grant access to an object type for a schema.  Prior to 23c, you had to grant access to every object of the entire schema.

4096 Columns

Tables in 23c can have even more columns with a maximum of 4096 columns.

Table Value Constructor

Group By Column Alias

If [NOT] Exists

Enhanced RETURNING Clause

Update via Join

Delete via Join

With Oracle Database 23c SQL Enhancements you benefit from

1. Improved Readability: leads to cleaner and more conciseness
2. Easier Migration: As organizations adopt multi-database strategies or migrate from one database to another, developers and database administrators will find it easier to transition from other database platforms to Oracle. 
3. Consistency across Platforms: The enhanced approach promotes consistency.
4. Enhanced Developer Productivity: The streamlined syntax saves developers time and effort, allowing them to focus on more critical aspects of their work. 

Oracle has taken a significant step towards making its SQL more intuitive and user-friendly. The streamlined approach not only simplifies construction but also facilitates easier migration and fosters consistency across database platforms. As a result, Oracle users can now enjoy a more seamless experience, enhancing their productivity and overall satisfaction with the database system.