Creating APEX code artifacts

Oracle Application Express is a good product to develop quick interfaces. In a business intelligence and data warehousing solution, this can be valuable to capture missing information or enhance business processes.

Getting ready

Oracle Application Express provides an export utility through the frontend, which creates an SQL script file. This script file can be used to install an APEX application within a new environment.

How to do it...

Open Oracle Application Express and perform the following steps:

  1. Navigate to Oracle Application Express Application Builder, normally at http://machine_name:port/apex, and log in using an administrator account, as shown in the following screenshot:
  2. Export the application by choosing the ...

Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.