1  

VARCHAR2(size)
NVARCHAR2(size)

Variable length character string having maximum lengthsizebytes. Maximumsizeis 4000, and minimum is 1. You must specifysizefor a VARCHAR2.

Variable-length character string having maximum lengthsizecharacters or bytes, depending on the choice of national character set. Maximumsizeis determined by the number of bytes required to store each character, with an upper limit of 4000 bytes. You must specifysizefor NVARCHAR2. 

2  

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. Has a total length equal to the defined precision, plus 1 if the scale is greater than 0 (for the decimal point). Has a decimal portion exactly equal to the size dictated by the scale. 

8  

LONG

Character data of variable length up to 2 gigabytes, or 2³¹-1 bytes.  

12  

DATE

Valid date range from January 1, 4712 BC to December 31, 4712 AD.  

23  

RAW(size)

Raw binary data of lengthsizebytes. Maximumsizeis 2000 bytes. You must specifysizefor a RAW value.  

24  

LONG RAW

Raw binary data of variable length up to 2 gigabytes.  

69  

ROWID

Hexadecimal string representing the unique address of a row in its table. This datatype is primarily for values returned by the ROWID pseudocolumn. 

96  

CHAR(size)
NCHAR(size)

Fixed length character data of lengthsizebytes. Maximumsizeis 2000 bytes. Default and minimumsizeis 1 byte.

Fixed-length character data of lengthsizecharacters or bytes, depending on the choice of national character set. Maximumsizeis determined by the number of bytes required to store each character, with an upper limit of 2000 bytes. Default and minimumsizeis 1 character or 1 byte, depending on the character set.  

106  

MLSLABEL

Binary format of an operating system label. This datatype is used for backward compatibility with Trusted Oracle.  

112  

CLOB
NCLOB

A character large object containing single byte characters. Varying-width character sets are not supported. Maximum size is 4 gigabytes.

A character large object containing fixed-width multi-byte characters. Varying-width character sets are not supported. Maximum size is 4 gigabytes. Stores national character set data.  

113  

BLOB

A binary large object. Maximum size is 4 gigabytes.  

114  

BFILE

Contains a locator to a large binary file stored outside the database. Enables byte stream I/O access to external LOBs residing on the database server. Maximum size is 4 gigabytes.