5.18.6 Accessing APEX Views

Query various views against APEX metadata.

APEX Views are data dictionary views that expose the metadata for applications. In APEX Views, you cannot only see the view, but you can also see the data they contain.

To access the APEX Views page:

1. Navigate to the Workspace home page.
2. Click the App Builder icon.
3. Select an application.

   The Application home page appears.

4. Click Utilities.
5. Click Oracle APEX Views.

   The APEX Views report appears. Use the Search bar at the top of the page to customize the display.

   Tip:

   Click Tree View to switch to a relational view of this information with expandable parent and children entries. The list of APEX dictionary views is also available by querying the APEX_DICTIONARY view.

6. Select a view.
7. On Selected Columns, configure the columns.
   1. From Select Columns use the controls to add and remove columns or change the column order.
   2. Click the Results button.
   The Results report appears.
8. To view the executed query, expand the Query region.
   You can also copy this query for reuse with SQL Commands or SQL Developer.
9. To download the Results, click the Download link.