Oracle 9i Tutorial : CREATE TABLE Syntax

Oracle 9i Tutorial : CREATE TABLE Syntax

•You must have:

–CREATE TABLE privilege

–A storage area

•You specify:

–Table name

–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