SQL> select to_char('10','xxxx') from dual;#十进制转换为十六进制
TO_CHAR('1
----------
a
----------
a
SQL> select to_char('1','xxxx') from dual;
TO_CHAR('1
----------
1
----------
1
SQL> select to_char('11','xxxx') from dual;
TO_CHAR('1
----------
b
----------
b
SQL> select to_number('016f','xxxx') from dual;#十六进制转换为十进制TO_NUMBER('016F','XXXX')
------------------------
367
------------------------
367
SQL>
SQL>
SQL> select bin_to_num(1,1) from dual;
SQL>
SQL> select bin_to_num(1,1) from dual;
BIN_TO_NUM(1,1)
---------------
3
---------------
3
SQL> select bin_to_num(1,1,1,1) from dual;
BIN_TO_NUM(1,1,1,1)
-------------------
15
-------------------
15
SQL> select to_number('016f','xxxx') from dual;#016f为ultraedit第2,3字节的十六
进制数,转换为十进制
TO_NUMBER('016F','XXXX')
------------------------
367
------------------------
367
#一定要在转换后的十进制次前面加上to_number函数,然后再用nls_charset_name
SQL> select nls_charset_name(to_number('367','xxxx')) from dual;
NLS_CHARSET_NAME(TO_NUMBER('367','XXXX'))
--------------------------------------------------------------------------------
UTF8
--------------------------------------------------------------------------------
UTF8
SQL> select nls_charset_name(to_number('367','xxxx')) from dual;
NLS_CHARSET_NAME(TO_NUMBER('367','XXXX'))
--------------------------------------------------------------------------------
UTF8
--------------------------------------------------------------------------------
UTF8
SQL> select nls_charset_name(to_number('354','xxxx')) from dual;
NLS_CHARSET_NAME(TO_NUMBER('354','XXXX'))
--------------------------------------------------------------------------------
ZHS16GBK
--------------------------------------------------------------------------------
ZHS16GBK
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/22835600/viewspace-1302370/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
ORA-01849
请登录后发表评论
登录
全部评论
