Viewing Tables or Views Utilizing User Interface Defaults

You can view tables or views utilizing user interface defaults by either navigating to the User Interface Defaults page or viewing the UI Defaults report in Object Browser.

Topics in this section include:

See Also:

"Managing Database Objects with Object Browser" in Oracle Application Express SQL Workshop and Utilities Guide.

Creating to User Interface Defaults

To create user interface defaults:

  1. On the Workspace home page, click the Application Builder icon.

    Application Builder home page appears.

  2. Select an application.

  3. On the Application, click Shared Components.

    The Shared Components page appears.

  4. Under User Interface, select User Interface Defaults.

    The User Interface Defaults page appears.

    The current schema displays to the right of the breadcrumb menu.

  5. To narrow the display, use the following controls at the top of the page and click Go:

    • Table/View - Enter a case insensitive query for a table or view name within the current schema.

    • Display - Determines the types of tables to display.

    • View - Make a selection to filter the view:

      • Icons (default) displays each table or view as a large icon.

      • Details displays each table or view as a line in a report, identifying the table or view name, the object type, and whether user interface defaults currently exist.

    • Display determines the number of items that display in the report.

  6. Select a specific table or view by selecting the name.

    The Table Defaults page appears.

  7. If no user interface defaults exist, click Create User Interface Defaults.

Tip:

You can also access the User Interface Defaults page by clicking User Interface Defaults on the Tasks list on either the Application Builder home or Applications home pages. See "About the Application Builder Home Page" and "About the Application Home Page".

Viewing the UI Defaults Report in Object Browser

To view the User Interface Details Report in Object Browser:

  1. On the Workspace home page, click SQL Workshop and then Object Browser.

    Object Browser appears.

  2. From the Object list, select either Tables or Views.

  3. From the Object Selection pane, select an object.

  4. Select the UI Defaults tab.

    The User Interface Defaults report appears displaying the following information:

    • Column Name - Indicates the name of the column.

    • Label - Specifies the default label text for items in a form and the heading for columns in reports.

    • Report Sequence - Specifies the sequence of items in a report.

    • Report Display - Specifies how the column should be displayed in a report.

    • Tabular Form Display - Specifies how an item should display in a tabular form.

    • Form Sequence - Specifies the sequence of items in a form.

    • Form Display - Specifies how items in a form display.

  5. To edit the user interface defaults, click Edit.

    The Table Defaults page appears.

  6. If no user interface defaults exist, click Create Defaults.