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)