17 Managing Application Data
Learn how to manage application data such as adding data loading capability to applications, using collections to temporarily store information, using REST Enabled SQL references to execute SQL or PL/SQL defined at the component-level on a remote database, use REST Data Sources to manage external web services, store REST Data Source server information as a Remote Server object, and store authentication credentials using Web Credentials, manage legacy Web services, access data with database links, and utilize DML to update or delete rows of a table.
- Creating Applications with Data Loading Capability
Create applications with data loading capability to enable end users to dynamically import data into a table within any schema to which they have access. - About Using Collections
Use collections to temporarily capture one or more nonscalar values. Collections enable you to store rows and columns currently in session state so they can be accessed, manipulated, or processed during a user's specific session. - Managing REST Enabled SQL References
Execute SQL queries or PL/SQL defined at the component-level on a remote database using REST Enabled SQL references. - Managing REST Data Sources
Oracle APEX REST Data Sources enable developers to access to REST services or generic JSON data feeds in applications. - Managing Remote Servers
Store REST Data Source server information as a Remote Server object. - Managing Web Credentials
Store authentication credentials for external REST services or REST Enabled SQL services. - Managing Generative AI in APEX
Create Generative AI Services to include AI features in App Builder and enable support for developers to include Generative AI in their applications. - Accessing Data with Database Links
Access data remotely by creating a database link.