Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Data Definition Statements

Data Definition Language (DDL) statements are used to create and maintain Oracle database objects. Because DDL statements can perform so many different functions, there are a large number of them, and many have a wide range of options and syntax choices. This section provides a reference to the syntax of these DDL SQL statements. (Data Manipulation Language, or DML, statements are described separately later in this chapter.)

In many cases, multiple DDL statements may operate on the same object type. For example, CREATE TABLE, ALTER TABLE, and DROP TABLE are all related DDL statements that operate on Oracle tables. For convenience, we have grouped these related DDL statements together in a single list. When you see a heading like CREATE/ALTER/DROP TABLE, this means that we provide the syntax for all three statements under that heading.

Many DDL statements are normally used only for administration of a database and are typically issued by a DBA. For this reason, many statements require specific privileges. Some statements also apply only when specific Oracle options, such as the Partition Option or Real Application Clusters, are installed.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page