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