You can use JDeveloper to generate DDL for any offline objects you have created. You can choose the objects to include, whether you need
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
You will generate a DDL script for some or all of the offline database objects you have created.
You will then run the script in your chosen database.