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