4 Using Oracle Application Express Utilities

This section describes how to use Oracle Application Express utilities to build SQL queries, load and unload data from an Oracle database, generate DDL, view object reports, manage User Interface Defaults, restore dropped database objects, compare schemas, monitor the database, and view database details.

Topics:

• Building SQL Queries with Query Builder

• Using the Data Workshop to Manage Data

• Generating DDL

• Managing Methods on Tables

• Managing User Interface Defaults

• Viewing Database Details

• Comparing Schemas

• Viewing Object Reports

• Monitoring the Database

• Using the Recycle Bin to View and Restore Dropped Objects