Managing Oracle Application Express Packaged Applications or Sample Code

You can install Oracle Application Express packaged applications and sample code.

  • Packaged Applications. These are applications that can be installed, run and removed. They are fully supported by Oracle. You can add users, manage user access, and make changes that meet your needs.

  • Sample Code. These are samples that illustrate a concept or demonstrate a technique. They can be installed, run, removed, viewed and modified.

Topics:

Installing Packaged Applications and Sample Code

The Oracle Application Express Application Builder, which is available with Oracle Database Cloud Service (Database Schema), allows you to quickly install and run a variety of built-in business process applications.

Video iconVideo

Tutorial iconTutorial

Follow these steps to install a packaged application or sample code:

  1. Access Oracle Database Cloud Service (Schema). See Accessing Oracle Database Cloud Service (Database Schema).

    The Oracle Application Express home page displays.

  2. Click the Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. Click the Packaged Applications tab.

    The Packaged Applications page displays showing all available packaged applications and sample code.

  4. Locate and click the packaged application or sample code you want to install.

    The application information page displays.

  5. Click Install Application.
  6. For Authentication, select one of the following and click Next:
    • Oracle Cloud Identity Management (default) - Users of this packaged application are managed through the Identity Console. See Managing Users and Roles in Getting Started with Oracle Cloud.

    • Application Express Accounts - Users of this packaged application are managed from the Application Express Administration. See Managing Application Express Users in Oracle Application Express Administration Guide.

  7. On the confirmation page, click Install Application.
  8. If you selected Application Express authentication, you need to add users from Oracle Application Express Administration before running the application. See Managing Application Express Users in Oracle Application Express Administration Guide.
  9. If you selected Oracle Cloud Identity Management, the users currently authorized with access to your service have access to this application. Use the Oracle Cloud portal to add users. See Managing Users and Roles in Getting Started with Oracle Cloud.
  10. Click Run Application.

Modifying Sample Code

After installing sample code, it can be modified just like any other Database or Websheet application you have created or imported.

See Modifying a Database Application and Modifying a Websheet Application.

Note:

Installed sample code can be modified. Installed packaged applications cannot be modified.

Removing Packaged Applications and Sample Code

Packaged applications and sample code can be removed from your Oracle Database Cloud Service (Database Schema) using Application Express.

Follow these steps to remove a packaged application or sample code:

  1. Access Oracle Database Cloud Service (Schema). See Accessing Oracle Database Cloud Service (Database Schema).

    The Oracle Application Express home page displays.

  2. Click the Application Builder.

    The Oracle Application Express Application Builder home page displays.

  3. Locate and click the packaged application or sample code you want to remove.

    The application information page displays.

  4. Click Remove.
  5. To confirm, click Remove Application.