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 UI 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
  Use Query Builder to build queries graphically by adding tables to a panel and selecting the columns to return.
• 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 (UI Defaults)
  Managing user interface (UI) defaults enables you to assign default UI properties, create default wizard, modify the table UI defaults, add new attributes, and export the UI 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.
• Navigating to Data Dictionary Cache
  Quickly navigate to Data Dictionary Cache in Administration Services.
• 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.
• Creating a Data Model Using AI
  Create a data model using the Generative AI Service already configured on the workspace.
• 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.