4.5 Generating DDL

With Oracle Application Express, you can generate data definition language (DDL) statements from the Oracle data dictionary.

You can use these scripts 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.

To generate a DDL statement:

1. On the Workspace home page, click the SQL Workshop.

2. Click Utilities.

3. Click Generate DDL.

   The Generate DDL page appears.

4. Click Create Script.

   The Generate DDL Wizard appears.

5. Select a database schema and click Next.

6. 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.

7. Click Generate DDL.

See Also:

• "Oracle Database SQL Language Reference" for information about DDL statements

• "The Data Dictionary" in Oracle Database Concepts for information about the data dictionary