Oracle APEX 26.1 The Complete Guide

Learn Oracle APEX the way you'll actually use it.

Most APEX learning is scattered. Blog posts for old versions, screenshots that don't match your builder, and toy demos that stop right where real apps begin. This book fixes that.

In 828 pages you build one real application, Orbit Sales, an order-management app for a fictional outdoor-gear retailer, and learn every part of Oracle APEX 26.1 along the way.

WHAT'S INSIDE
- 828 pages, 48 chapters, 6 parts
- 474 real screenshots, all taken on APEX 26.1
- Free code on GitHub: the sample schema, every example by chapter, and the finished app
- "New in 26.1" boxes wherever something changed in this release
- Summary and review questions at the end of every chapter

WHAT YOU'LL LEARN
- Install anywhere: Docker or native on Windows, Linux and macOS, ORDS in depth, or free cloud workspaces
- Build every kind of page: reports, interactive grids, forms, cards, faceted search, charts, maps and calendars
- Page logic: items, session state, validations, processes, dynamic actions, Ajax and JavaScript
- Security: authentication, authorization, session state protection and Content Security Policy
- Workflows and automations: approvals, parallel flows, the Unified Task List, e-mail and push notifications
- Generative AI: AI agents with tools, an in-app assistant, APEX_AI in PL/SQL, and local models with Ollama
- Production: RESTful services with ORDS, plug-ins, debugging, APEXlang, deployment and administration

FULLY UP TO DATE WITH APEX 26.1
AI agents with tools, APEXlang, parallel workflows, Data Reporter, a stricter CSP, the new Iris theme style, and support for six AI providers including OpenAI, Anthropic, Google Gemini and Ollama. Plus an upgrade checklist for older apps.

NO PAID LICENSE NEEDED
Everything runs on free software: Oracle AI Database 26ai Free, APEX, ORDS, SQLcl and VS Code.

WHO IT'S FOR
- Developers new to APEX who know some SQL
- Oracle Forms developers moving to the web
- Experienced APEX developers catching up with 26.1
- DBAs who install and administer APEX

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.