Oracle 10.2 Data Types (oacdty)

Oracle 10.2 data types (oacdty) for use when you’re (bravely) exploring an Oracle trace:

1     VARCHAR2 or NVARCHAR2
2     NUMBER
8     LONG
9     NCHAR VARYING, VARCHAR
12   DATE
23   RAW
24   LONG RAW
25   LONG UB2
26   LONG SB4
58   ANYDATA
69   ROWID
96   CHAR or NCHAR
100 BINARY FLOAT
101 BINARY DOUBLE
102 REF CURSOR
104 UROWID
105 MLSLABEL
106 MLSLABEL
111 XMLTYPE (TABLE or REF)
112 CLOB or NCLOB
113 BLOB
114 BFILE
121 TYPE (USER-DEFINED)
122 TYPE (TABLE OF RECORD)
123 TYPE (VARRAY)
178 TIME
179 TIME WITH TIME ZONE
180 TIMESTAMP
181 TIMESTAMP WITH TIME ZONE
182 INTERVAL YEAR TO MONTH
183 INTERVAL DAY TO SECOND
208 UROWID
231 TIMESTAMP WITH LOCAL TIME ZONE