Data Definition Language (DDL)
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 ...
Get Oracle Database 10g Express Edition PHP Web Programming now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
