5.15.7 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 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.

6. Select a view.
7. On Selected Columns, select columns from Select Columns and click the Results button.
   The Results report appears.
8. On Results:
   • To view the query that was executed, expand the Query region . You can copy this query for reuse with SQL Commands or SQL Developer.
   • Click Download, to download to a file.