Internal Datatypes in Oracle

December 14th, 2006 by Rajender Singh · No Comments

One more important term which really stuck me while writting “Understanding Internal DATE Storage” post, was “Internal Datatype”. Although the name itself sugggest that it is a internal coding of oracle to store different data type, but I was curious of what other more datatype are there….

I did some research on it and found out following others internal datatype codes.

Datatype Code	Datatype Name
114	BFILE
96	CHAR, NCHAR
12	DATE
183	INTERVAL DAY TO SECOND REF
182	INTERVAL YEAR TO MONTH REF
8	LONG
24	LONG RAW
2	NUMBER
23	RAW
111	REF
113	REF BLOB
112	REF CLOB, REF NCLOB
11	ROWID
180	TIMESTAMP
231	TIMESTAMP WITH LOCAL TIME ZONE
181	TIMESTAMP WITH TIME ZONE
208	UROWID
108	User-defined type (object type, VARRAY, nested table)
1	VARCHAR2, NVARCHAR2
106	MLSLABEL