Exporting User Interface Defaults

Previous
Previous
Next
Next

Exporting User Interface Defaults is useful when you plan to develop on the target machine.

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.

To export User Interface Defaults from the Export page:

  1. On the Database Home Page, click the Application Builder icon.

  2. Select an application.

  3. On the Application Builder home page, click Export/Import.

  4. When prompted to select a task, select Export and click Next.

  5. Click User Interface Defaults at the top of the page.

  6. On the Export User Interface Defaults page:

    1. From Schema, select the schema that owns the table associated with the User Interface Defaults.

    2. From 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.

  7. Click Export.

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

  1. On the Database Home Page, click the Application Builder icon.

  2. Select an application.

  3. On the Application Builder home page, click Shared Components.

  4. Under User Interface, select User Interface Defaults.

    The User Interface Defaults page appears.

  5. Click Export.

    The Export page appears.

  6. Click Themes at the top of the page.

  7. On the Export User Interface Defaults page:

    1. From Schema, select the schema that owns the table associated with the User Interface Defaults.

    2. From 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.

  8. Click Export.