Generate SQL from Offline Database Objects Wizard - Generate Options

Use to specify how to update the database. You can choose to:

Create or replace the objects in the database. If you have chosen to generate a SQL file, it will contain CREATE statements.
Update existing database schema objects. JDeveloper first reconciles the offline database definitions against the objects in the database schema to identify the changes necessary. If you have chosen to generate a SQL file, it may contain CREATE, REPLACE and ALTER statements.

Note: If you are reconciling against a database schema, there is the possibility that you will generate SQL scripts that will drop foreign keys. For more information, refer to Offline Tables and Foreign Keys.

In either case, you can choose to:

CREATE (or replace) the chosen objects: Select this option to generate SQL files containing CREATE statements.
Update (reconcile) the chosen objects: Select this option to generate SQL files containing CREATE , REPLACE and ALTER statements.
Generate SQL scripts: Select this option to generate SQL files.
Perform Operation with the database: Select this option to make the changes directly to the database.