Exporting User Interface Defaults

Exporting User Interface Defaults is useful when you plan to develop on a target system.

When you export User Interface Defaults, all User Interface Defaults for the selected schema are exported to a single SQL Command script. When prompted, save this file to your hard drive. The file contains an API call to create table hints by making calls to the application PL/SQL API. You can use this file to import User Interface Defaults to another database and Oracle Application Express instance.

Exporting User Interface Defaults from the Export Page

To export User Interface Defaults from the Export page:

Navigate to the Export page:
1. On the Workspace home page, click the Application Builder icon.
2. Select an application.
3. On the Application home page, click Export/Import.
4. On the Export/Import page, click Export and click Next.
Click the User Interface Defaults tab at the top of the page.
On the Export User Interface Defaults page, select the following:
1. Schema - Select the schema that owns the table associated with the User Interface Defaults.
2. File Format - Select how rows in the export file will be formatted:
  - Choose UNIX to have the resulting file contain rows delimited by line feeds.
  - Choose DOS to have the resulting file contain rows delimited by carriage returns and line feeds.
3. Click Export User Interface Defaults.

Exporting User Interface Defaults from the User Interface Defaults Page

To export User Interface Defaults from the User Interface Defaults page:

On the Workspace home page, click the Application Builder icon.
Select an application.
On the Application Builder home page, click Shared Components.
Under User Interface, select User Interface Defaults.

The User Interface Defaults page appears.
From the Tasks list, click Export.
On the Export User Interface Defaults page, select the following:
1. Schema - Select the schema that owns the table associated with the User Interface Defaults.
2. File Format - Select how rows in the export file will be formatted:
  - Choose UNIX to have the resulting file contain rows delimited by line feeds.
  - Choose DOS to have the resulting file contain rows delimited by carriage returns and line feeds.
3. Click Export User Interface Defaults.