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.