1, DECODE (c.CHARSETFORM, 2, 'NVARCHAR2', 'VARCHAR2'), 2, DECODE (c.scale, NULL, DECODE (c.precision#, NULL, 'NUMBER', 'FLOAT' ), 'NUMBER' ), 8, 'LONG', 9, DECODE (c.CHARSETFORM, 2, 'NCHAR VARYING', 'VARCHAR'), 12, 'DATE', 23, 'RAW', 24, 'LONG RAW', 58, NVL2 (ac.synobj#, (SELECT o.NAME FROM SYS.obj$ o WHERE o.obj# = ac.synobj#), ot.NAME), 69, 'ROWID', 96, DECODE (c.CHARSETFORM, 2, 'NCHAR', 'CHAR'), 105, 'MLSLABEL', 106, 'MLSLABEL', 111, NVL2 (ac.synobj#, (SELECT o.NAME FROM SYS.obj$ o WHERE o.obj# = ac.synobj#), ot.NAME), 112, DECODE (c.CHARSETFORM, 2, 'NCLOB', 'CLOB'), 113, 'BLOB', 114, 'BFILE', 115, 'CFILE', 121, NVL2 (ac.synobj#, (SELECT o.NAME FROM SYS.obj$ o WHERE o.obj# = ac.synobj#), ot.NAME), 122, NVL2 (ac.synobj#, (SELECT o.NAME FROM SYS.obj$ o WHERE o.obj# = ac.synobj#), ot.NAME), 123, NVL2 (ac.synobj#, (SELECT o.NAME FROM SYS.obj$ o WHERE o.obj# = ac.synobj#), ot.NAME), 178, 'TIME(' || c.scale || ')', 179, 'TIME(' || c.scale || ')' || ' WITH TIME ZONE', 180, 'TIMESTAMP(' || c.scale || ')', 181, 'TIMESTAMP(' || c.scale || ')' || ' WITH TIME ZONE', 231, 'TIMESTAMP(' || c.scale || ')' || ' WITH LOCAL TIME ZONE', 182, 'INTERVAL YEAR(' || c.precision# || ') TO MONTH', 183, 'INTERVAL DAY(' || c.precision# || ') TO SECOND(' || c.scale || ')', 208, 'UROWID', 'UNDEFINED') |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/767125/viewspace-912536/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/767125/viewspace-912536/