Generating DDL Scripts for Creating Database Objects

A data definition language (DDL) is for creating database objects. Generating DDL scripts with Oracle SQL Developer Data Modeler is quite simple, and it can be done over and over again to find the right settings to get the right kinds of scripts. The difficult task is to decide what kind of DDL files you want. Do you want a version of a whole database at a certain time in just one file, or do you want a file per object or something else? Where do you plan to keep the files, and who will have access to them? What are you going to do with these files? Do you need a file for creating ...

Get Oracle SQL Developer Data Modeler for Database Design Mastery now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.