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 the 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
  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.
• Accessing Data with Database Links
  Access data remotely by creating a database link.