October 2006
Intermediate to advanced
720 pages
17h 56m
English
The DDL commands let you create, replace, alter, drop, rename, and truncate database objects, permissions, and settings. You require a database instance before you can you create, replace, alter, drop, rename, and truncate database objects. When you installed the Oracle database, the installation script created a clone of a sample database. Alternatively, the installation program could have used the CREATE command to build a database instance. After creating the database instance, you can then use the ALTER command to change settings for the instance or for given sessions. Sessions last the duration of a connection to the database instance.
The DDL section is organized into subsections and covers
Managing tables ...
Read now
Unlock full access