Exporting User Interface Defaults

Exporting User Interface Defaults is useful when you plan to develop on a target system. User Interface Defaults are divided into two categories, the Table Dictionary, and the Attribute Dictionary.

The Table Dictionary consists is specific to tables and columns within a selected schema. These defaults are used over those defined in the Attribute Dictionary.
The Attribute Dictionary contains a set of attributes about a column that is used in creating forms and reports. The definitions are matched by column name and a particular definition can be shared among several columns by using synonyms.

When you export User Interface Defaults, all User Interface Defaults for the selected dictionary and 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. On the Application Builder home page, click Export.
On the Export page, click User Interface Defaults.
On the Export User Interface Defaults - Table Dictionary 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.
To export Attribute Dictionary, click Attribute Dictionary tab.
Click Export.

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 SQL Workshop icon.
Click Utilities.
Click User Interface Defaults.

The User Interface Defaults page appears.
Select the dictionary you want to export:
- Manage Table Dictionary - select this button to export specific tables and columns within a selected schema.
- Manage Attribute Dictionary - select this button to export a set of column attributes used to create forms and reports.
Under Tasks, click Export link.
On the Table Dictionary page, select the file format:
- 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.
Click Export.