dump与utl_raw

utl_raw作为dump的逆函数的一些用法：

数字

SQL> select dump(10,16) from dual;

DUMP(10,16)

-----------------

Typ=2 Len=2: c1,b

SQL> select utl_raw.cast_to_number('c10b') value from dual;

     VALUE

----------

        10

字符

SQL> select dump('oracle 10g',16) from dual;

DUMP('ORACLE10G',16)

--------------------------------------------

Typ=96 Len=10: 6f,72,61,63,6c,65,20,31,30,67

SQL> select utl_raw.cast_to_varchar2('6f7261636c6520313067') value from dual;

VALUE

-------------------------------------------------------------------------------

oracle 10g

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

转载于:http://blog.itpub.net/29014732/viewspace-774190/