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 necessary options. Note the DOS or UNIX file format. Use the appropriate file format for the environment. When saving the file, use the name for the application without spaces, as follows:
3. In Subversion, create a folder under Baseline, named...