Database Reference
In-Depth Information
Oracle's SQL Developer product also has a tool that lets you generate DDL for a se-
lected schema.
Figure 10-5
shows the splash screen of the SQL Developer Database
Export tool.
Figure 10-5.
The first screen of the SQL Developer Database Export tool
This tool is very similar to the APEX wizard, but it gives you more control over the
format and contents of the output, including whether to include schema names, storage
clauses, grants, and so on. Another benefit of SQL Developer is the ability to export
the data that exists in the tables. This comes in very handy for seed data that is needed
for the system to function properly.
Whether you choose to use the APEX-based tool or SQL Developer, generating the
object-creation scripts for a new system is straightforward.
Existing Applications
