Oracle Database 23ai : Where to find information

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

• Oracle New Features Guide

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.

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

Application Development

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

• Oracle Database 23ai Now Available in the Cloud
• Test Drive Oracle Database 23ai for Free

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

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

Security

• SQL Firewall
• Schema-level privilege grants
• Database Developer Role

OLTP and Core Database

• Automatic Tablespace Shrink

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

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

• Introducing JSON Relational Duality
• Document and Relational in the SAME database!
• JSON Schema

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

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!

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

• Raft-based replication in Globally Distributed Database

OLTP and Core Database

• Multiple direct load
• 4000+ columns (Wide Tables)

Performance

• Priority Transactions
• SQL Analysis Report
• Fast Ingest enhancements
• SQL Transpiler

Security

• SQL Firewall
• Schema Privileges
• Developer Role

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

Public link

Please use the above public link if you want to share this noodl on another website.