5 Using Oracle Application Express Utilities
Oracle Application Express provides 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.
- Using Data Workshop
Use Data Workshop to load and unload data to the database. - Using Query Builder
Using Query Builder, you can search and filter database objects, select objects and columns, create relationships between objects, view formatted query results, and save queries with little or no SQL knowledge. - Using Quick SQL
Rapidly design and prototype data models using a markdown-like shorthand syntax that expands to standards-based Oracle SQL. - Using Sample Datasets
Use Sample datasets to build sample applications. - Generating DDL
With Oracle Application Express, you can generate data definition language (DDL) statements from the Oracle data dictionary. - Managing User Interface Defaults
Managing user interface defaults enables you to assign default interface properties, create default wizard, modify the table user interface defaults, add new attributes, and export the user interface defaults. - Comparing Schemas
You can run a report that compares database objects in two schemas, displaying differences between them. You can compare all objects in the schemas or limit your report to specific objects. - Managing Methods on Tables
The Managing Methods on Tables utility enables you to create an application programming interface, or package, based on a specified table. - Using the Recycle Bin
You can use the Recycle Bin to view and restore dropped database objects. - Viewing Object Reports
SQL Workshop Utilities includes a variety of object reports to help you better manage the objects in your database. - Viewing Database Details
If you have an account that has been granted a database administrator role, you can view details about your database on the About Database page. - Monitoring the Database
The reports available on the Database Monitor page provide a database-wide view of the database sessions, system statistics, SQL statements, and longer operations.