Generating Changes from the Offline Database Object to the Database
Whether or not you have created a database diagram, you can generate changes to the database by right-clicking the database object or objects in the Applications Navigator and selecting Generate To. You can then select a JDeveloper connection, or you can generate a SQL script or SXML.
When you choose to generate to a JDeveloper connection as depicted in the slide, or to SQL Scripts, this also invokes the Generate SQL from Offline Database Objects Wizard. Its pages enable you to specify whether to create, replace, or alter, and whether to generate a SQL script, along with script options. If you choose to generate to SXML, an XML file is created and opens in the editor.