Oracle APEX
Oracle Application Express (APEX) is a low-code development platform that enables you to build scalable, secure enterprise apps with world-class features.
APIs
Oracle APEX REST Data Services API
RESTful API for Oracle APEX applications enabling data access and manipulation through REST endpoints.
Oracle APEX SQL Workshop API
API for accessing SQL Workshop functionality programmatically.
Oracle APEX Application API
API for managing APEX applications, pages, and components.
Oracle REST Data Services (ORDS) API
REST API framework integrated with APEX for creating RESTful services including modules, templates, handlers, privileges, roles, OAuth clients, and AutoREST-enabled objects.
Oracle APEX Cloud REST API
REST APIs for provisioning and managing Oracle APEX instances in Oracle Cloud Infrastructure, including workspace and application lifecycle management.
Oracle APEX Export and Import API
PL/SQL and REST APIs for exporting and importing APEX applications, workspaces, and components using APEX_EXPORT and related packages.
Oracle APEX Approval and Workflow API
PL/SQL APIs for managing approvals, human tasks, and workflows in APEX applications using the APEX_APPROVAL and workflow packages.
Oracle APEX Utility API
The APEX_UTIL PL/SQL package provides utility functions for user management, authentication, session management, and other common APEX operations.
Oracle APEX Generative AI API
APIs for integrating generative AI capabilities into APEX applications, including chat, text generation, and vector embeddings introduced in APEX 24.2.
Oracle ORDS Database API
REST API for Oracle Database management and monitoring operations through ORDS, including pluggable database management, data export, and performance monitoring.
Oracle APEX REST Administration API
REST Administration API enabling APEX instance administrators to perform administrative functions over REST and HTTP protocols for machine-to-machine communication.
Features
Visual drag-and-drop application builder for creating enterprise web applications without extensive coding.
Built-in ORDS integration for exposing database objects and custom logic as REST APIs.
Native AI capabilities including chat, text generation, and vector embeddings for intelligent applications.
Built-in workflow engine with human task management and approval chains for business process automation.
Build installable progressive web applications with offline capabilities and native-like user experience.
Seamless deployment and management on Oracle Cloud Infrastructure with automated provisioning.
Use Cases
Rapidly build and deploy internal enterprise applications for HR, finance, and operations.
Expose Oracle Database tables and views as RESTful services using ORDS AutoREST.
Automate business approval processes and multi-step workflows with the APEX workflow engine.
Build self-service data entry and management portals for business users with built-in validation.
Integrate generative AI features into business applications for intelligent data processing and insights.
Integrations
Native integration with Oracle Database for data access, PL/SQL execution, and database object management.
Deploy APEX applications on OCI with autonomous database and cloud-native infrastructure services.
ORDS provides the REST API layer for APEX applications and database services.
Single sign-on and identity management integration for enterprise authentication.
LDAP-based authentication and user synchronization with Active Directory environments.