Data type

Data type SQL DATATYPES

NUMBER: INDICATE THE COLUMN CONTAINS NUMBER.

EXAMPLE: NUMBER (6, 2)

32155.01

The number in parentheses following this data type refers to the maximum of digits that the column may contain. A second number following the data type specifies the number of digits that the right of the decimal point in the number value.

VARCHAR2: INDICATE THE CLOUMN STORS A VARIABLE NUMBER OF CHARACTERS.

Example: VARCHAR2 (10)

                  ‘ADAM’

THE NUMBER IN PARENTHESES FOLLOWING THIS DATATYPE SPECIFIES THE MAXIMUM OF CHARACTERS ALLOWED.

DATE: THE DATE DATATYPE INDICATES THAT A COLUMN CONTAINS A DATE AND TIME THE VAIID DATE RANGE IS BETWEEN JANUARY 1.14712 B.C.AND DECEMBER 31.9999 A.D.

EXAMPLE: 25-SEP-2011

CHAR: THE CHAR DATATYPE INDICATES THAT THE COLUMN STORES A FIXED-LENGTH CHARACTER VALUE . THE NUMBER IN PARENTHRSES FOLLOWING THIS DATATYPE SPECIFIES THE NUMBER OF CHARACTERS ALWAYS STORED.

EXAMPLE : CHAR(3)

EMD

KNY

AD#