Oracle 9i Tutorial

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

Leave a Reply