ORACLE CREATE TABLE (11g)

CREATE Table Statement

CREATE table [schema.] Table name (column datatype [DEFAULT expr][, ...]);

Specify a default value for the column during the insertion

... hire_date date DEFAULT sysdate,...

The default value must satisfy the data type definition of the column

CREATE TABLE Hire_dates (ID number (8), hire_date date default sysdate);

CREATE TABLE Dept (deptno Number (2), dname varchar2 (+), loc varchar2, create_date date default sysdate);

Data Type	Dsecription
VARCHAR2 (size)	Variable long character data
char (size)	Fixed-length character data
Number (P,s)	Variable Long Value data
Date	Date and time values
Long	Variable long character data (up to 2GB)
Clob	Character data (up to 4GB maximum)
Raw and log raw	Binary data
Blob	Binary data (up to 4GB maximum)
bfile	Store binary data for external files (up to 4GB)
rowID	Base-64 line unique address for system encoding

ORACLE CREATE TABLE (11g)