Generating DDL

With Oracle Application Express, you can generate data definition language statements from the Oracle data dictionary. These scripts can be used to create or re-create database schema objects. The scripts can be generated to display inline or saved as a script file. You can generate the create scripts for all objects for a specific schema, specific object types, or specific objects.

If you run Oracle Application Express with Oracle Database 10g release 1 (10.1) or later, you can generate data definition language statements from the Oracle data dictionary. These scripts can be used to create or re-create 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. On the Workspace home page, click the Utilities icon.

2. Click Generate DDL.

   The Generate DDL page appears.

3. Click Create Script.

   The Generate DDL Wizard appears.

4. Select a database schema and click Next.

5. Define the object type:

   1. Output - Specify an output format. Select either Display Inline or Save As Script File.

   2. Check All - Select this option to include all object types for which to generate DDL.

   3. Object Type - Select the object types for which to generate DDL.

   4. To select object names for the selected object types, click Next and follow the on-screen instructions.

6. Click Generate DDL.