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

Purpose

Find More Information

Table

Stores data

This chapter

View

Used for security and to hide complexity

Chapter 12

Index

Improves data access speed

Chapter 12

Sequence

Generates unique key values

Chapter 12

Synonym

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.