经常有人会疑惑dump出来的typ=1啊2啊,96等数据不知道什么意思．其实他们就是Oracle内部的数据类型的代码．下面我将常见的Data Type Numeric Type Codes 列举如下，希望对同志们有点帮助：

Data Type Numeric Type Codes
0	placeholder for procedures with no arguments
1	VARCHAR, VARCHAR2, STRING, NVARCHAR2
2	NUMBER, INTEGER, SMALLINT, REAL, FLOAT, DECIMAL
3	BINARY_INTEGER, PLS_INTEGER, POSITIVE, NATURAL
8	LONG
11	ROWID (old)
12	DATE
23	RAW
24	LONG RAW
58	OPAQUE TYPE
69	ROWID (new)
96	CHAR (ANSI FIXED CHAR), NCHAR, CHARACTER
100	BINARY_FLOAT
101	BINARY_DOUBLE
106	MLSLABEL
121	OBJECT
122	NESTED TABLE
123	VARRAY
178	TIME
179	TIME WITH TIME ZONE
180	TIMESTAMP
181	TIMESTAMP WITH TIME ZONE
231	TIMESTAMP WITH LOCAL TIME ZONE
250	PL/SQL RECORD
251	PL/SQL TABLE
252	PL/SQL BOOLEAN

ITPub博客

Oracle中的数据类型代码表