ORACLE APEX · RELEASE 26.1
Oracle APEX Developer Guide
English edition
A local multilingual edition for Oracle APEX developers, preserving the current Chinese release while providing a separate English reading path.
25 CHAPTERS
Chapter Navigation
Each chapter is a standalone HTML page with shared navigation, images, source links, and responsive reading behavior.
Introduction
1 Introduction Oracle APEX is a complete low-code platform for rapidly building secure, scalable enterprise apps of any size and complexity. Using APEX App Builder in a browser, you def...
Working with Local Data
2 Working with Local Data Enterprise applications thrive on data, and Oracle APEX makes working with any data simple and efficient. While it's also easy to integrate remote data, most A...
Simplifying User Experience Design
3 Simplifying User Experience Design Oracle APEX simplifies designing experiences for users working with your application data. In App Builder , creating and enhancing pages is producti...
Referencing Data Values in Pages
4 Referencing Data Values in Pages While working on your pages, you'll often need to reference the values of page items or report columns for formatting, in queries, and in business log...
Visualizing and Analyzing Data
5 Visualizing and Analyzing Data Oracle APEX 's native region components simplify visualizing and analyzing data. After choosing the region type that fits your requirements, configure t...
Enhancing Search for End-Users
6 Enhancing Search for End-Users Searching for data is a fundamental part of any enterprise app. Oracle APEX has multiple native components you can use to deliver compelling search expe...
Adding Functionality with Plug-ins
7 Adding Functionality with Plug-ins When native APEX features don't fully meet your needs, you can easily extend the platform with plug-ins. These shared components add new functionali...
Understanding Page Flow & Session State
8 Understanding Page Flow & Session State Your app helps end users get their jobs done, and they expect easy access to all tasks they can perform. Your navigation menu shows them what b...
Editing Data in a Grid
9 Editing Data in a Grid Edit tabular data with Interactive Grid, overriding its save behavior for special cases, and customizing it with JavaScript APIs. Interactive Grid lets users wo...
Working with Master/Detail Data
10 Working with Master/Detail Data Work with related data using stacked grids, side-by-side selection, and drill-down editing pages. Study three Master/Detail page styles generated by t...
Controlling Access with Users and Roles
11 Controlling Access with Users and Roles Only authenticated users can access your app. They see only the pages and data they are authorized to use, and can perform only the actions th...
Applying Artificial Intelligence
12 Applying Artificial Intelligence Add AI features that help users explore data, ask questions, generate text, complete requests, and find results by meaning. Start by configuring the ...
Integrating Remote Data
13 Integrating Remote Data The fastest way to work with data in Oracle APEX is to use tables or views in the local database. But many applications also need to integrate with remote dat...
Exposing APIs for Integration
14 Exposing APIs for Integration Expose REST APIs for external integrations while reusing business logic and securing access. A PL/SQL package provides an application programming interf...
Geocoding Addresses
15 Geocoding Addresses Geocoding an address identifies its geographic coordinates. Having longitude and latitude information for an address makes it easy to: Visualize it on a map Compu...
Uploading, Viewing, and Downloading Files
16 Uploading, Viewing, and Downloading Files Use Image Upload for images, File Upload for other file types, and native download features to serve stored files. Use an Image Upload page ...
Loading External Data
17 Loading External Data Load external data from Excel, XML, JSON, or CSV files using declarative pages, page processes, or PL/SQL APIs. Create a Data Load Definition to set up a profil...
Grouping Logic and Background Execution
18 Grouping Logic and Background Execution Group related page processes in an execution chain and offload longer-running tasks to the background. Use an Execution Chain page process to ...
Executing Repetitive Processing
19 Executing Repetitive Processing Use an Automation in Shared Components to define repetitive processing. Understanding Key Automation Concepts An Automation lets you define a recurrin...
Notifying End Users
20 Notifying End Users Notify end users with messages, emails, and push notifications from declarative settings or code. Displaying Success and Error Messages Show users success and err...
Producing Pixel-Perfect Reports
21 Producing Pixel-Perfect Reports Use a Report Query with an associated Report Layout to produce a pixel-perfect PDF report. The report sources in the Report Query definition identify ...
Translating Your Application
22 Translating Your Application Translate your app with Text Messages, Application Translations, bulk exports, and App Builder editing tools. Use Text Messages and Application Translati...
Understanding Application Lifecycle
23 Understanding Application Lifecycle Learn how teams maintain and enhance an Oracle APEX application over time using proven lifecycle practices. As users work with your app, they’ll r...
Working with APEXlang
24 Working with APEXlang APEXlang is a practical text representation of your application that works both inside App Builder and with external tools. Its declarative definitions let you ...
Automating Business Processes
25 Automating Business Processes Automate business processes with APEX Workflows to coordinate work and show progress clearly. A business process is a sequence of steps your organizatio...