Oracle 8 Data Types

Code	Internal Datatype	Description
1	VARCHAR2(size) NVARCHAR2(size)	Variable length character string having maximum length size bytes. Maximum size is 4000, and minimum is 1. You must specify size for a VARCHAR2. Variable-length character string having maximum length size characters or bytes, depending on the choice of national character set. Maximum size is determined by the number of bytes required to store each character, with an upper limit of 4000 bytes. You must specify size for 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.
8	LONG	Character data of variable length up to 2 gigabytes, or 2^31 -1 bytes.
12	DATE	Valid date range from January 1, 4712 BC to December 31, 4712 AD.
23	RAW(size)	Raw binary data of length size bytes. Maximum size is 2000 bytes. You must specify size for a RAW value.
24	LONG RAW	Raw binary data of variable length up to 2 gigabytes.
69	ROWID (see note below)	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 length size bytes. Maximum size is 2000 bytes. Default and minimum size is 1 byte. Fixed-length character data of length size characters or bytes, depending on the choice of national character set. Maximum size is determined by the number of bytes required to store each character, with an upper limit of 2000 bytes. Default and minimum size is 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.