pkg_number_trans.f_hex_to_dec()和pkg_number_trans.f_hex_to_bin()

SQL> select sys.pkg_number_trans.f_hex_to_dec('c')/4 file# FROM dual;

     FILE#
----------
         3

SQL> select sys.pkg_number_trans.f_hex_to_dec('1ce4') as blk# FROM dual;

BLK#
----------------------
7396
注释：将表示十六进制的数值（或是字符串）转换成十进制数值

SQL> col c1 format a10
SQL> col c2 format a10
SQL> col c3 format a10
SQL> select sys.pkg_number_trans.f_hex_to_bin(19) as c1,
  2  sys.pkg_number_trans.f_hex_to_bin(25) as c2,
  3  sys.pkg_number_trans.f_hex_to_bin(09) as c3 from dual;

C1         C2         C3
---------- ---------- ----------
11001      100101     1001

注释：将表示十进制的数值转换成二进制数值的字符串形式

            pkg_number_trans是Oracle的包，即封装函数、存储过程等的容器。