ITPub博客

首页 > 数据库 > Oracle > [20141009]oracle数据类型内部编码.txt

[20141009]oracle数据类型内部编码.txt

原创 Oracle 作者:lfree 时间:2014-10-09 10:47:38 0 删除 编辑

[20141009]oracle数据类型内部编码.txt

--了解一些oracle内部数据类型的内部编码

SCOTT@test> select distinct type# from sys.col$ order by 1;
  TYPE#
-------
      0
      1
      2
      8
     12
     23
     24
     25
     29
     58
     69
     96
    101
    105
    111
    112
    113
    114
    121
    122
    123
    180
    181
    182
    183
    208
    231
27 rows selected.

--查询找到如下链接:
http://arjudba.blogspot.com/2009/03/oracle-datatype-internal-code.html

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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/267265/viewspace-1292597/,如需转载,请注明出处,否则将追究法律责任。

全部评论
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。

注册时间:2008-01-03

  • 博文量
    2698
  • 访问量
    6480320