#Oracle23i

Interesting New Features:

Lock-Free Reservations : Lock-free column value reservations allow applications to reserve part of a value in a column without locking the row; for example, reserve part of a bank account balance or reserve an item in inventory without locking out all other operations on the bank account or item.

JavaScript Stored Procedures : Developers can now create stored procedures using JavaScript in the database. This functionality also allows developers to leverage the huge number of JavaScript libraries.

Priority Transactions : Low priority transactions that block high priority transactions can be automatically aborted. This feature reduces the administrative burden on the DBA while maintaining high transaction throughput.

Data Use Case Domains : Data Use Case Domains allow developers to declare the intended usage of data (columns) in a centralized and light-weight manner. For example, you can declare a column to hold an email, URL, password, currency, and so on. Applications can use Data Use Case Domains to automatically generate code or verify values.

Many Data Type and SQL Enhancements:

• SQL BOOLEAN Data Type
• Direct Joins for UPDATE and DELETE Statements
• Unicode 15.0 Support
• SELECT Without FROM Clause
• GROUP BY Column Alias or Position

Up to 4096 columns: This feature simplifies the development of applications needing large numbers of attributes, such as ML and IoT.

Schema Privileges : System privileges can now be granted at the schema level. This feature simplifies the privilege management process and as a result, makes it easy to secure databases.

Developer Role : A new role allows administrators to quickly assign developers only the privileges they need to design, build, and deploy applications for the Oracle Database.

SQL Firewall : Included in Oracle Database, SQL Firewall provides real-time protection against common database attacks by monitoring and blocking unauthorized SQL and SQL injection attacks, no matter the SQL execution path.