Oracle 23ai Help Center

Your AI-Native
Database Guide

Comprehensive technical support, tutorials, and insights for Oracle Database 23ai — the first AI-native database from Oracle.

Browse Support Read the Blog
oracle23ai — sqlplus
-- Oracle Database 23ai
-- AI Vector Search Example
 
SQL> CREATE TABLE docs (
   id      NUMBER,
   content CLOB,
   embed   VECTOR(1536)
);
 
Table created.
 
SQL> SELECT id, VECTOR_DISTANCE
     (embed, :query_vec)
     FROM docs
     ORDER BY 2 FETCH FIRST 5 ROWS ONLY;
 
SQL>
All Systems Operational
Oracle Cloud Infrastructure
23ai Documentation API
Support Portal
Knowledge Base
// Search the knowledge base
⌕
// Technical Support

Find Your Answer

View All Articles →
🚀
New Features
Oracle 23ai New Features: Everything You Need to Know
A comprehensive overview of Oracle Database 23ai's 300+ new features — from AI Vector Search and JSON Duality Views to SQL Firewall, Schema Privileges, True Cache, Property Graph, and developer quality-of-life improvements.
New 16 min
🔄
Comparison
Key Differences Between Oracle 19c and 23ai
A detailed side-by-side comparison across AI, SQL, security, performance, architecture, and support lifecycle to help you decide when to upgrade.
Updated 14 min read
📄
Getting Started
Installing Oracle Database 23ai Free
Complete installation guide for Oracle Database 23ai Free on Oracle Linux, Windows, and Docker. Includes system requirements, step-by-step instructions, post-install configuration, and troubleshooting tips.
beginner 20 min
// Blog & Insights

Latest from the Field

All Posts →
23ai
Deep Dive · March 21, 2025
Deep Dive
Key Differences Between Oracle 19c and 23ai

A detailed side-by-side comparison of Oracle Database 19c and 23ai across AI capabilities, SQL and PL/SQL, security, performance, architecture, developer experience, and support lifecycle — to help you decide when and whether to upgrade.

Oracle 23ai Help Team March 21, 2025 14 min
Deep Dive
Key Differences Between Oracle 19c and 23ai
March 21, 2025 14 min
Deep Dive
Oracle 23ai New Features: Everything You Need to Know
March 20, 2025 16 min
Deep Dive
Oracle 23ai: Everything You Need to Know About the VECTOR Data Type
March 14, 2025 12 min
Tutorial
JSON Relational Duality Views: Bridging Relational and Document Worlds
February 28, 2025 9 min
Performance
Benchmarking HNSW vs IVF Vector Indexes in Oracle 23ai
February 20, 2025 15 min
// Release History

Version Timeline

Current Release · 2024
Oracle 23ai CURRENT

AI-native release featuring native vector storage, AI Functions, JSON Duality Views, and schema-level privileges.

VECTOR type AI Functions JSON Duality Schema Privileges SQL Domains True Cache Property Graph
LTS Release · 2019
Oracle 19c

Long-term support release. Stable, widely deployed, supported through extended support.

Automatic Indexing Real-Time Stats JSON Enhancement Multitenant
LTS Release · 2017
Oracle 18c / 12c
Multitenant CDB In-Memory Approximate Query
23ai Key Numbers
3000+
New Features
∞
Vector Dimensions
5
Distance Metrics
Free
Developer Edition