Google News
logo
PL/SQL - Interview Questions
Describe a few Data Types used in SQL?
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.
Advertisement