Creating a Table

Syntax

CREATE TABLE <table_name> (<column_name> <datatype> 
	[DEFAULT <expr>] [<column_constraint>] | 
        [<table_constraint>] 
                          [,(<column_name> <datatype> 
	[DEFAULT <expr>] [<column_constraint>] | 
	[<table_constraint>]] ...);

Data Types

CHAR(<size>) - fixed length char

DATE - valid date from 4712 B.C. to 4712 A.D.

INTEGER(<size>) - an integer with <size> digits maximum

NUMBER(<size>,<d>) - a decimal number with <size> digits before the decimal point and <d> digits after the decimal point.

VARCHAR2(<size>) - a variable length character string up to <size> bytes. ALWAYS USE VARCHAR2 not VARCHAR.

Example

SQL> create table emp
  2  (empno number(4) not null,
  3   ename varchar2(10),
  4   job   varchar2(9),
  5   mgr   number(4),
  6   hiredate date,
  7   sal number(7,2),
  8   comm number(7,2),
  9   deptno number(2));

Table created.