Data types v14

The following table shows the built-in general-purpose data types:

NameAliasDescription
BLOBLONG RAW, RAW(n), BYTEABinary data
BOOLEANLogical Boolean (true/false)
CHAR [ (n) ]CHARACTER [ (n) ]Fixed-length character string of n characters
CLOBLONG, LONG VARCHARLong character string
DATETIMESTAMPDate and time to the second
DOUBLE PRECISIONFLOAT, FLOAT(25) – FLOAT(53)Double precision floating-point number
INTEGERINT, BINARY_INTEGER, PLS_INTEGERSigned four-byte integer
NUMBERDEC, DECIMAL, NUMERICExact numeric with optional decimal places
NUMBER(p [, s ])DEC(p [, s ]),DECIMAL(p [, s ]),NUMERIC(p [, s ])Exact numeric of maximum precision, p, and optional scale, s
REALFLOAT(1) – FLOAT(24)Single precision floating-point number
TIMESTAMP [ (p) ]Date and time with optional, fractional second precision, p
TIMESTAMP [ (p) ] WITH TIME ZONEDate and time with optional, fractional second precision, p, and with time zone
VARCHAR2(n)CHAR VARYING(n), CHARACTER VARYING(n), VARCHAR(n)Variable-length character string with a maximum length of n characters
XMLTYPEXML data

numeric_types character_types binary_data date_time_types boolean_type xml_type