Generating DDL

If you are running Oracle HTML DB with Oracle Database 10g release 1 (10.1) or later, you can generate Data Definition Language (DDL) statements from the Oracle data dictionary. These scripts can be used to create or recreate database schema objects. The scripts can be generated to the screen, or they can be saved as a SQL Script. You can generate the create scripts for all objects for a specific schema, specific object types, or specific objects.

To generate a DDL statement:

1. Click the SQL Workshop icon on the Workspace home page.

2. Click Utilities and then Generate DDL.

   The Generate DDL Wizard appears.

3. Follow the on-screen instructions.