Oracle Database 26ai SQL and PL/SQL

Every SQL function, statement, and developer package of Oracle AI Database 26ai — each with a real example and its real output.

This is the complete guide to SQL and PL/SQL for developers who work with Oracle AI Database 26ai, the long-term support release after 19c. Every entry explains what a feature is for, shows its syntax, and proves it with an example that ran in Oracle AI Database 26ai Free, printed together with the output it produced.

• SQL functions: character, numeric, date and time, conversion, aggregate, analytic, JSON, XML, vector, and machine learning
• Queries: joins, subqueries, WITH and recursive queries, hierarchical and analytic queries, PIVOT, MATCH_RECOGNIZE, flashback, and SQL property graphs
• DML and DDL: transactions and locking, tables of every kind, views, indexes, domains, assertions, users, and privileges
• PL/SQL: cursors, collections, exceptions, packages, triggers, dynamic SQL, bulk processing, object types, and SQL macros
• Nearly 100 built-in packages: DBMS_SQL, DBMS_LOB, UTL_HTTP, DBMS_SCHEDULER, DBMS_AQ, DBMS_CRYPTO, DBMS_METADATA, DBMS_VECTOR, DBMS_MLE, and more
• New since 19c: BOOLEAN and VECTOR types, JSON duality views, AI Vector Search with embeddings, JavaScript in the database

All 677 examples use Nimbus Air, a complete airline sample schema, and are free to download with their output from GitHub.