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
