O'Reilly logo

Oracle® SQL by Example, Third Edition by Alice Rischert

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required