Generating DDL

With Oracle Application Express, you can generate Data Definition Language (DDL) 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 are running Oracle Application Express 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. 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.