Database Reference
In-Depth Information
Figure 18.1
Demonstrating
CREATE TABLE
... AS Subquery.
So far we have looked at different types of tables and various methods for
creating those different table types. Now we examine syntax for the CREATE
TABLE command, which is used for, you guessed it, creating tables.
18.2
CREATE TABLE Syntax
The syntax of the CREATE TABLE command is highly complex at first
glance in Oracle documentation. However, the focus of this topic is on
Oracle SQL and not database administration. Database administration
functionality for the CREATE TABLE command includes any physical
storage parameters such as tablespace locations and most types of physical
properties. Therefore, we get to leave a lot of the syntax out because we are
only dealing with Oracle SQL. This makes it a lot easier, but unfortunately
not easy enough. So syntax for the CREATE TABLE command has to be
divided into sections. Let's begin with a very simple form of the syntax, per-
haps it could be called a pseudo-like syntax, for creating tables, as shown in
Figure 18.3.
What we do from this point onward is to pass through each table type in
turn, examining syntax and describing by example.
