Oracle Database 23ai is the latest long-term support release of the leading enterprise database, boasting over 300 new features and focused on three main areas.
- AI for Data
- Dev for Data
- Mission Critical for Data
You can find details in the blog “Oracle Database 23ai : Now Generally Available” on these areas plus the release schedule and where you can download it.
This blog will provide details on where you can find additional information on the release. It will be updated regularly as new blogs, videos, demos, and hands on labs becomes available.
Documentation
You can find documentation for the release here. For details on all the new features. We’d recommend these manuals in particular to get started with
Blogs
There is already a wide selection of blogs available describing the features of Oracle Database 23ai. We’ll update this section as new and important blogs become available.
Application Development
AI Vector Search
- Oracle Announces General Availability of AI Vector Search in Oracle Database 23ai
- Fortifying Data Security in AI with Oracle’s GenAI Service
JSON
- JSON Relational Duality: The Revolutionary Unification of Document, Object, and Relational Models
- Working with JSON-Relational Duality Views and Oracle APEX
- JSON Schema and Data Use Case Domains
MLE/JavaScript
- Working with JSON in Multilingual Engine/JavaScript
- Ad-hoc MLE JavaScript: DBMS_MLE
- Using a proxy with the JavaScript fetch API and UTL_HTTP
- Using faker-js/Faker to generate test data respecting referential integrity
- Using faker-js/SimpleFaker to produce test data
- Performance Monitoring for In-Database JavaScript
- Dealing securely with state changes in Multilingual Engine
- Using the Operating System’s certificate store instead of an Oracle wallet
- An Introduction to Post Execution Debugging
- More fun while coding: local dev-environment for MLE
- Enhanced JavaScript Support
- Managing JavaScript modules and environment in Database Actions
- Creating MLE JavaScript Modules in Database Actions
- Using the JavaScript fetch API
- Linting MLE JavaScript Modules in Continuous Integration Pipelines
- Using JavaScript community modules
- MLE type mapping: passing JSON to JavaScript functions
Oracle Cloud Infrastructure
SQL
- Schema Annotations – the new metadata
- List Months of the Year or Days of the Week in Oracle SQL with Enumeration Domains
- More Boolean features
- How to Document Database Objects with Annotations
- Enhanced Querying: Eliminating the “FROM DUAL” Clause
- New value constructor
- Less coding using Data Use Case Domains
- Improved Table Management in Oracle 23c: Introducing the “IF [NOT] EXISTS” Clause
- Simplifying Query Development with Improved GROUP BY and HAVING Clauses
- Boolean Data Type
- Using QuickSQL to generate table DDL and sample data
- UPDATE and DELETE Statements via direct Joins
- Better error messages means less errors
- Introducing the New/Old Returning Clause
- Aggregation over INTERVAL Data Types
Microservices
- Building real-time multi-cloud AI Microservices using TxEventQ, Sagas, TrueCache in Oracle Database 23ai
- Kafka interopability
- Kafka-compatible Java APIs for Transactional Event Queues published
- Playing with Kafka Java Client for TEQ – creating the simplest of producers and consumers
Database Drivers and Application Connectivity
- JDBC Configuration via App Config Providers and Vaults
- JDBC seamless authentication with OCI IAM and Azure AD
- Java and .NET Application Observability with OpenTelemetry and Oracle Database
- How to Make Application Continuity Most Effective
- Oracle .NET Application Continuity — Getting Started
- HikariCP Best Practices for Oracle Database and Spring Boot
General
- New full-text search: Ubiquitous Database Search
- What’s New for Java Developers
- Oracle REST Data Services 22.3 brings new REST APIs for Transactional Event Queueing
- Introducing the Oracle Database Observability Exporter
- Announcing ODP.NET 23ai — New Async, OpenTelemetry, AI Vector Search Support, and More
High Availability and Distributed Database
- Oracle Globally Distributed Database supports RAFT Replication
- Oracle’s very own database connection proxy, CMAN-TDM, brings in per-PDB pooling capabilities
- Multi-pool Database Resident Connection Pooling (DRCP)
Performance
- Introducing Oracle True Cache
- Priority Transactions with high, medium and low priority transaction
- Fast Ingest Enhancements
- Lock-free reservations
- SQL Transpiler – automatic PL/SQL conversion into SQL
- Unleashing the Power of Lock-Free Reservations
- Oracle Database 23ai In-Memory Deep Vectorization Enhancements
Security
- SQL Firewall
- Schema-level privilege grants
- Database Developer Role
- Wallet-less access to external resources
OLTP and Core Database
Spatial and Graph
- Operational Property Graphs
- Get started with Property Graphs
- Property Graphs in SQL Developer release 23.1
Hands on Labs
Hands on labs are a great way to get started with some of the features on Oracle Database 23ai. You can find the entire collection of labs here. We’d like to call out the following labs to get started with
- Exploring JSON Relational Duality Views in 23ai Free using SQL
- Exploring JSON Relational Duality Views in 23ai Free with Java
- Exploring Operational Property Graphs in 23ai Free
- AutoREST with JSON Relational Duality Views in 23ai Free
- Simple Data Driven applications using JavaScript in Oracle Database 23ai Free-Developer Release
- SQL, JSON, and MongoDB API: Unify worlds with Oracle Database 23ai Free
Courses
There are a series of courses that can help you get up to speed on Oracle Database 23ai and get ready for certification. All four courses have hands on labs.
- Oracle Database 23ai: New Features for Developers
- Oracle Database 23ai: New Features for Administrators
- Oracle Database 23ai: Administration Workshop
- Oracle Database 23ai: SQL Workshop
Videos
Explore Oracle Database 23ai through online videos. Learn at your own pace with easy-to-follow tutorials and demonstrations. As new videos become available, we will update this section.
Application Development
JSON
SQL
- Simple SQL
- GROUP BY column alias
- If NOT exists
- Update/Delete with JOIN
- Schema Annotations
- Table Value Constructor
- Select Without From Clause
- PL/SQL JSON constructor support for aggregate types
- Lock-free column value reservations
- Boolean Data type
- Better Error Messages
- Data Use Case Domains
- DEFAULT ON NULL
- RETURNING NEW/OLD
- 23ai – What is a TRANSPILER ?
- Interval aggregation CEIL/FLOOR on dates
- Easy conversion from PLSQL to JSON
General
- MongoDB-compatible API
- JavaScript stored procedures
- Kafka APIs
- Application Observability with Enhanced Diagnostic and OpenTelemetry Integration
- Oracle Text – find ANY data in ANY table easily!
- Hybrid Read Only Mode
- Phonetic matching improvements
Database Drivers and Application Connectivity
- Effortless Connection Management with Implicit Pooling
- Database driver asynchronous programming and pipelining
- Transparent Application Continuity (TAC) for Java
- Async & Reactive Programming, R2DBC, Java Virtual Threads, and Database Pipelining
- Connect Power BI Desktop with Azure Active Directory and Oracle Database
High Availability and Distributed Database
OLTP and Core Database
Performance
- Priority Transactions
- SQL Analysis Report
- Fast Ingest enhancements
- SQL Transpiler
- Database Locking has been changed FOREVER!
Security
Spatial and Graph
- Operational Property Graphs with new SQL Syntax
- Create, Query, and Visualize a Property Graph with SQL Oracle Database 23c Free – Developer Release
- When Property Graphs Join SQL – OCW 2022
Dominic Giles
Distinguished Product Manager
Dominic is a Distinguished Product Manager for the Oracle Database, responsible for the overall product offering. He’s worked for Oracle for over 33 years since the release of Oracle Database 5. One of Dominic’s primary roles is to update customers on new functionality and gather feedback for future releases. You can follow him on twitter @dominic_giles.
Killian Lynch
Product Manager
Oracle Database Product Manager