tell me more icon Generating a DDL Script

You can use JDeveloper to generate DDL for any offline objects you have created. You can choose the objects to include, whether you need CREATE, REPLACE or ALTER keywords, and other options for the DDL. You can choose to generate the DDL straight into a specific database or to generate a .sql script, using the Generate SQL from Database Objects wizard.

To launch the wizard, you will right-click the DBDEMO folder in the Application Navigator and choose Generate .

Application Navigator context menu

Generate SQL from Database Objects wizard

You will generate a DDL script for some or all of the offline database objects you have created.

Generate SQL from Database Objects wizard, step 2

You will then run the script in your chosen database.

Copyright © 1997, 2009, Oracle. All rights reserved.