Friday, April 16, 2010

Data Definition Language (DDL) in oracle

Specification notation for defining the database schema
E.g. create table account ( account-number char(10), balance integer);
DDL compiler generates a set of tables stored in a data dictionary
Data dictionary contains metadata (i.e., data about data)
database schema
Data storage and definition language
language in which the storage structure and access methods used by the database system are specified
Usually an extension of the data definition language

No comments:

Post a Comment