Oracle 9i Tutorial : CREATE TABLE Syntax
•You must have:
–CREATE TABLE privilege
–A storage area
–Column name, column data type, and column size
CREATE TABLE Statement
Create tables to store data by executing the SQL CREATE TABLE statement. This statement is one of the data definition language (DDL) statements, that are covered in subsequent lessons. DDL statements are a subset of SQL statements used to create, modify, or remove Oracle9i database structures. These statements have an immediate effect on the database, and they also record information in the data dictionary.
To create a table, a user must have the CREATE TABLE privilege and a storage area in which to create objects. The database administrator uses data control language (DCL) statements, which are covered in a later lesson, to grant privileges to users.
In the syntax:
schema is the same as the owner’s name
table is the name of the table
DEFAULT expr specifies a default value if a value is omitted in the INSERT statement
column is the name of the column
datatype is the column’s data type and length