18 Managing Application Data
Learn how to manage application data such as adding data loading capability to applications, using collections to temporarily store information, or how to work with data from different local and remote data sources, including tables, SQL queries or JSON documents.
- 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. - Working with Duality Views and JSON Sources
Learn about creating Duality View and JSON Sources to retrieve data from a local or a remote database. - Managing REST Data Sources
Oracle APEX REST Data Sources enable developers to access to REST services or generic JSON data feeds in applications. - 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 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.