Oracle Database 26ai SQL and PL/SQL: The Complete Developer's Guide

By: Vinish Kapoor

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 learningQueries: joins, subqueries, WITH and recursive queries, hierarchical and analytic queries, PIVOT, MATCH_RECOGNIZE, flashback, and SQL property graphsDML and DDL: transactions and locking, tables of every kind, views, indexes, domains, assertions, users, and privilegesPL/SQL: cursors, collections, exceptions, packages, triggers, dynamic SQL, bulk processing, object types, and SQL macrosNearly 100 built-in packages: DBMS_SQL, DBMS_LOB, UTL_HTTP, DBMS_SCHEDULER, DBMS_AQ, DBMS_CRYPTO, DBMS_METADATA, DBMS_VECTOR, DBMS_MLE, and moreNew 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.

• Format: Paperback
• Language: English
• ISBN: B0HL5Z7LSK
• ISBN13: 9798177170534
• Release Date: September 2026
• Publisher: Independently published
• Length: 700 Pages
• Weight: 2.62 lbs.
• Dimensions: 9.3" x 1.6" x 7.5"