Oracle中的数据类型代码表

来源:互联网 发布:鸿合电子白板软件安装 编辑:程序博客网 时间:2024/05/29 10:20

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

Data Type Numeric Type Codes0placeholder for procedures with no arguments1VARCHAR, VARCHAR2, STRING, NVARCHAR22NUMBER, INTEGER, SMALLINT, REAL, FLOAT, DECIMAL3BINARY_INTEGER, PLS_INTEGER, POSITIVE, NATURAL8LONG11ROWID (old)12DATE23RAW24LONG RAW58OPAQUE TYPE69ROWID (new)96CHAR (ANSI FIXED CHAR), NCHAR, CHARACTER100BINARY_FLOAT101BINARY_DOUBLE106MLSLABEL121OBJECT122NESTED TABLE123VARRAY178TIME179TIME WITH TIME ZONE180TIMESTAMP181TIMESTAMP WITH TIME ZONE231TIMESTAMP WITH LOCAL TIME ZONE250PL/SQL RECORD251PL/SQL TABLE252PL/SQL BOOLEAN

0 0
原创粉丝点击