The
data types available with SQL are given below;
|
Internal Data type
|
Description
|
|
VARCHAR2
(size)
|
Variable
length character string maximum length size bytes. Maximum size is 2000 and
minimum is 1. You must specify size for a VARCHAR2.
|
|
NUMBER
(p,s)
|
Number
having precision p and scale s. The precision p can range from 1 to 38. The
scale s can range from -84 to 127.
|
|
LONG
|
Character
data of variable length up to 2 gigabytes, or 231-1 bytes.
|
|
DATE
|
Valid date
range from January 1,4712 BC to December 31, 4712 AD.
|
|
RAW (size)
|
Raw binary
data of length size bytes. Maximum size is 255 bytes. You must specify size
of a RAW value.
|
|
LONG RAW
|
Raw binary
data of variable length up to 2 gigabytes.
|
|
ROWID
|
Hexadecimal
string representing the unique address of a row in its table. This data type
is primarily for values returned by the ROWID pseudo column.
|
|
CHAR(size)
|
Fixed
length character data of length size byte. Maximum size is 255. Default and
minimum size is 1 byte.
|
No comments:
Post a Comment