Database Reference
In-Depth Information
SQL Data Definition
Statements
The main SQL definition statements in an Oracle 10G environment are shown in
Figure
11-1
. These statements relate to the six basic types of database objects in
Oracle — tables, indexes, views, constraints, synonyms, and sequences. Other more
advanced types of database objects include databases, table-spaces, data-files, users, user
profiles, functions, and procedures.
Figure 11-1.
Commonly Used SQL Definition Statements
This chapter will focus on tables, synonyms, sequences and indexes; a discussion of
the more advanced objects will follow in subsequent chapters. The chapter will proceed
under the following subtopics:
•
Overview of Oracle's SQL Environment
•
Database Creation
•
Database Management
•
Tablespace Creation
•
Tablespace Management
•
Table Creation Statement
•
Dropping or Modifying a Table
•
Working With Indexes