5 Using SQL Workshop Utilities

SQL Workshop 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 Data Generator
  Use the Data Generator utility to create Blueprints and then generate sample data.
• 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
  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.