Oracle datatype internal code representation

As it is shown in oracle datatype internal code every datatype in oracle has its internal code. In this example every oracle datatype along with their corresponding internal code is shown.


Datatype Code
-------------------------------------- -------
1. VARCHAR2(size [BYTE | CHAR]) 01
2. NVARCHAR2(size) 01
3. NUMBER[(precision [, scale]]) 02
4. LONG 08
5. DATE 12
6. BINARY_FLOAT 21
7. BINARY_DOUBLE 22
8. RAW(size) 23
9. LONG RAW 24
10.ROWID 69
11.CHAR [(size [BYTE | CHAR])] 96
12.NCHAR[(size)] 96
13.CLOB 112
14.NCLOB 112
15.BLOB 113
16.BFILE 114
17.TIMESTAMP [(fractional_seconds)] 180
18.TIMESTAMP [(fractional_seconds)] WITH TIME ZONE 181
19.INTERVAL YEAR [(year_precision)] TO MONTH 182
20.INTERVAL DAY [(day_precision)] TO SECOND [(fractional_seconds)] 183
21.UROWID [(size)] 208
22.TIMESTAMP [(fractional_seconds)] WITH LOCAL TIME ZONE 231