Oracle APEX 26.1 API by Example

Every Oracle APEX API. Run, and shown with its real output.

The official reference tells you what a function takes. It rarely shows what it returns, how it behaves on a real page, or what to combine it with. This book runs every one of them and shows you.

Every method and event of the APEX JavaScript API and every procedure and function of its PL/SQL packages, more than 1,850 APIs, each with an example that ran in APEX 26.1 and the output it really produced. Plus 32 practical recipes for the tasks you meet in every application.

WHAT'S INSIDE
- 1,853 APIs documented, JavaScript and PL/SQL
- 518 runnable examples, each with its real output
- 32 practical recipes for everyday tasks
- All 63 APEX_ PL/SQL packages with their 917 procedures and functions
- 23 JavaScript namespaces, 13 interfaces and 9 widgets with 615 methods and 72 events
- Free code on GitHub: the API Lab application and every example

HOW EVERY ENTRY WORKS
Each API follows the same layout: what it's for, its syntax and parameters, a short example that runs in the book's API Lab, and exactly what that example printed. Find any API by task in the contents, or by name in the full index.

32 RECIPES YOU'LL ACTUALLY USE
Get the selected rows of an interactive grid, add a toolbar or delete button, refresh a report when its dialog closes, fly a map to a feature, save with Ctrl+S, and more. Each recipe tells you where the code goes and shows the result.

WHAT THE DOCS DON'T TELL YOU
Running every example turned up 18 places where APEX 26.1 behaves differently from its documentation. Appendix B collects them, along with everything new in 26.1. Appendix A lists 47 deprecated APIs and what to use instead.

NEW IN APEX 26.1
APEX_AI agents with tools and JSON schemas, named templates and htmlBuilder for strict CSP, the interactiveReportRegion interface, grid cell ranges, new workflow and task APIs, APEX_DB_DICTIONARY and more, all marked with a New in 26.1 badge.

WHO IT'S FOR
APEX developers who write JavaScript in their pages and PL/SQL behind them, and want to know exactly what each API does before they use it.

FREE TO RUN
Everything runs on Oracle AI Database 26ai Free and APEX, using the same ORBIT sample schema as the author's first book, Oracle APEX 26.1: The Complete Guide. This book stands on its own; you don't need the first one.

ABOUT THE AUTHOR
Vinish Kapoor is an Oracle ACE Pro and an APEX developer and architect with over twenty years of Oracle experience. He runs vinish.dev, read by developers worldwide for its APEX, SQL and PL/SQL tutorials.