Oracle索引的dumpleafblock(三)
F:\oracle\product\10.2.0\db_1\BIN>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Apr 10 13:32:40 2015
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
13:32:41 sys@FS> select scott.f_get_from_dump('31,30,36,31,31','varchar2') from
dual;
SCOTT.F_GET_FROM_DUMP('31,30,36,31,31','VARCHAR2')
--------------------------------------------------------------------------------
10611 -------------------------------------------------------->索引列的实际值
Elapsed: 00:00:00.00
13:32:58 sys@FS> select scott.f_get_from_dump('78,73,04,08,0f,3c,19','date') fro
m dual;
SCOTT.F_GET_FROM_DUMP('78,73,04,08,0F,3C,19','DATE')
--------------------------------------------------------------------------------
2015-4-8 14:59:24---------------------------------------------->索引列的实际值
Elapsed: 00:00:00.00
13:33:10 sys@FS>
或者用这个函数：
13:33:10 sys@FS> select utl_raw.cast_to_varchar2('3130363131') name from dual;
NAME
--------------------------------------------------------------------------------
--------------------
10611