18 Managing Application Data

Learn how to manage application data: add data loading capability, use collections to temporarily store information, execute SQL or PL/SQL defined at the component-level on a remote database, manage external web services through Web Source Modules, Remote Servers, and Web Credentials, manage legacy Web services, accessing data with database links, and utilizing Data Manipulation Language (DML) to update or delete rows of a table.

  • Creating Applications with Data Loading Capability
    Create applications with data loading capability that enable end users to dynamically import data into a table within any schema to which the they have access.
  • About Using Collections
    Collections enable you to temporarily capture one or more nonscalar values. You can use collections 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 Web Source Modules
    Web Source Modules act as a reference to one or multiple external web services. A module can contain one or many Web Source Operations which are the references to a concrete external web service.
  • Managing Remote Servers
    A Remote Server is separate entity that stores Web Source server information. Remote Servers can be shared among multiple Web Sources, thus enabling you to information such as the Base URL or Authentication.
  • Managing Web Credentials
    Manage secure credentials to connect to REST Enabled SQL or other REST services.
  • Managing Legacy Web Services
    Legacy Web services enable applications to interact with one another over the web in a platform-neutral, language independent environment.
  • Accessing Data with Database Links
    Access data remotely by creating a database link.
  • About DML Locking
    Use automatic Data Manipulation Language (DML) in Oracle Application Express to update or delete rows of a table.