Previous Next JavaScript must be enabled to correctly display this content

## 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.

Note:

To learn more about using Web Services in Oracle APEX with Autonomous AI Database, see Use Web Services with Oracle APEX in Using Oracle Autonomous AI Database Serverless.

- Working with Sample Data
  Learn about accessing sample data available in Oracle APEX.
- 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.