Satya's DBA Blog: Top Oracle Database 23c new features

July 16, 2023

New Features in Oracle Database 23c

Oracle 23c - Long-Term Support release (succeeding 19c), with 5 years of Premier Support followed by 3 years of Extended Support.

23c Oracle Database released on April 2023.

Here are some new features of Oracle 23c, out of 300+ new features and enhancements.

We can use SELECT without FROM clause. No need to use the DUAL table.
At last, error messages are more verbose/clear, and will explain why a statement failed to execute.
Until Oracle Database 21c, we can have up to 1000 columns in a table. But 23c onwards, we can define 4096 columns in a table.
OKafka, for Oracle Database <=> Kafka integration.
JavaScript stored procedures. And In-Database JavaScript.
JSON Schema can be defined on a table column.
Real-time SQL plan management.
New developer dole – quickly provides a user with useful privileges for doing database development, Instead of granting connect, resource to the user.
Schema level privileges.
We can use column aliases (instead of entire expressions) in GROUP BY and HAVING clauses.
Sharding will be easier.
Able to define metadata for database objects.
Gradual password rollover.
Like in MySQL, we can keep new IF EXISTS and IF NOT EXIST clauses in DDL statements
Table Value Constructor - TVC (like in SQL Server) – allows grouping multiple rows of data in a single DML or SELECT statement.
Oracle 23c onwards, RETURN clause for MERGE statement and also returning OLD column value for UPDATE.
Oracle RAC on Kubernetes (K8s).