Data Types is a specific storage format used to store column values. Few data types used in SQL are :
VARCHAR2(size) : Minimum size is ‘1
’ and Maximum size is ‘4000
’
CHAR(size) : Minimum size is ‘1
’and Maximum size is ‘2000
’
NUMBER(P,S) : " Precision" can range from 1 to 38 and the “Scale
” can range from -84 to 127.
DATE
LONG : 2GB
CLOB : 4GB
RAW (size) : Maximum size is 2000
LONG RAW : 2GB
BLOB : 4GB
BFILE : 4GB
ROWID : A 64 base number system representing the unique address of a row in the table.