oracle进制转换to_number_to_char_bin_to_num

SQL> select to_char('10','xxxx') from dual;#十进制转换为十六进制
TO_CHAR('1
----------
    a
SQL> select to_char('1','xxxx') from dual;
TO_CHAR('1
----------
    1
SQL> select to_char('11','xxxx') from dual;
TO_CHAR('1
----------
    b
SQL> select to_number('016f','xxxx') from dual;#十六进制转换为十进制TO_NUMBER('016F','XXXX')
------------------------
                     367
SQL>
SQL>
SQL> select bin_to_num(1,1) from dual;
BIN_TO_NUM(1,1)
---------------
              3
SQL> select bin_to_num(1,1,1,1) from dual;
BIN_TO_NUM(1,1,1,1)
-------------------
                 15
 
 
 
 
SQL> select to_number('016f','xxxx') from dual;#016f为ultraedit第2,3字节的十六
      进制数,转换为十进制
TO_NUMBER('016F','XXXX')
------------------------
                     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
SQL> select nls_charset_name(to_number('367','xxxx')) from dual;
NLS_CHARSET_NAME(TO_NUMBER('367','XXXX'))
--------------------------------------------------------------------------------
UTF8
SQL> select nls_charset_name(to_number('354','xxxx')) from dual;
NLS_CHARSET_NAME(TO_NUMBER('354','XXXX'))
--------------------------------------------------------------------------------
ZHS16GBK
请使用浏览器的分享功能分享到微信等