July 16, 2023

Top Oracle Database 23c new features

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).

Related Oracle Articles:  Oracle Database 21c new features     Postgres 15 new features

1 comment: