Database Reference
In-Depth Information
Figure 18.2
Creating a Table
Using Oracle
Enterprise
Manager.
18.3
Creating Different Table Types
An easy way of simplifying CREATE TABLE syntax is to divide it up into
the different table types, as already briefly described in this chapter. XML-
Type tables will be ignored in this section because they are extremely simple
and covered in Chapter 17.
Note:
It is important to remember that different table types do not always
fit precisely within the classifications assigned to them here. For example,
an IOT or a temporary table can be relational or object tables and vice
versa. The table types are simply divided neatly to facilitate ease of compre-
hension for the reader.
18.3.1
Creating Relational Tables
A relational table is termed
because of the way in which tables are
linked together. We get to that shortly and in more detail in Chapter 20
when discussing constraints. The syntax for creating a simple relational
relational
