十六进制到十进制:
SQL> select to_number('01','xxxx') from dual;
TO_NUMBER('01','XXXX')
----------------------
1
十进制到十六进制:
SQL> select to_char('221','xxxx') from dual;
TO_CHAR('2
----------
dd
二进制到十进制:
SQL> select bin_to_num(1,1,1,1) from dual;
BIN_TO_NUM(1,1,1,1)
-------------------
15
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11782778/viewspace-615035/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/11782778/viewspace-615035/