The Oracle APEX Developer’s Companion is a practical guide to building trusted enterprise apps. It covers the full spectrum of APEX development: data, UX, search, security, integration, files, APIs, reporting, translation, automation, workflow, and natural-language AI for users. Each chapter uses a simple example, often based on the familiar EMP table, with enough screenshots to keep you focused on understanding the ideas rather than on recreating every click. Use it to teach colleagues, learn APEX, or to see what the platform makes possible.
The final chapter, Automating Business Processes, follows two end-to-end scenarios at a fictitious medical facility, showing how APEX Workflow streamlines operations and orchestrates many platform features in a realistic example.
| Chapter | Learn How to Use Oracle APEX To… |
|---|---|
| Introduction | Build secure, scalable enterprise apps fast. |
| Working with Local Data | Work with any data simply and efficiently. |
| Simplifying User Experience Design | Design clear, data-rich user experiences quickly. |
| Referencing Data Values in Pages | Use item and column values anywhere you need to. |
| Visualizing and Analyzing Data | Turn data into insight with native regions. |
| Enhancing Search for End-Users | Help users easily find the right data. |
| Adding Functionality with Plug-ins | Extend APEX beyond built-in features. |
| Understanding Page Flow & Session State | Guide users smoothly through multi-step work. |
| Editing Data in a Grid | Edit tabular data and customize as needed. |
| Working with Master/Detail Data | Present and edit related data. |
| Controlling Access with Users and Roles | Secure your app and shape the UI with roles. |
| Applying Artificial Intelligence | Turn natural language into insights and actions. |
| Integrating Remote Data | Connect your app to remote data sources. |
| Exposing APIs for Integration | Publish secure APIs that reuse your business logic. |
| Geocoding Addresses | Turn addresses into geographic coordinates. |
| Uploading, Viewing, and Downloading Files | Upload, store, view, and download files. |
| Loading External Data | Import Excel, XML, JSON, and CSV data. |
| Grouping Logic and Background Execution | Organize logic and run long tasks in the background. |
| Executing Repetitive Processing | Automate recurring work. |
| Notifying End Users | Show messages, send emails, and push notifications. |
| Producing Pixel-Perfect Reports | Generate polished PDF output with your data. |
| Translating Your Application | Support users across languages. |
| Understanding Application Lifecycle | Evolve apps with proven practices. |
| Working with APEXlang | Manage readable artifacts with agents and other tools. |
| Automating Business Processes | Coordinate people, work, and progress. |