Chapter 11. CREATE, ALTER, and DROP Tables

This chapter introduces you to the Data Definition Language (DDL) commands associated with tables, the type of database object most frequently used. Table 11.1 provides you with an overview of other commonly used object types discussed in later chapters.

Table 11.1. Commonly Used Database Object Types

Database Object


Find More Information


Stores data

This chapter


Used for security and to hide complexity

Chapter 12


Improves data access speed

Chapter 12


Generates unique key values

Chapter 12


Provides an alternative name for a database object

Chapter 14

Directory ...

Get Oracle® SQL by Example, Third Edition now with O’Reilly online learning.

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