Oracle提供标准函数，对字符集名称及ID进行转换

oracle提供标准函数，对字符集名称及id进行转换

sql> select nls_charset_id('zhs16gbk') from dual;

nls_charset_id('zhs16gbk')
--------------------------
                       852

1 row selected.

sql> select nls_charset_name(852) from dual;

nls_char
--------
zhs16gbk

1 row selected.

十进制转换十六进制:

sql> select to_char('852','xxxx') from dual;

to_ch
-----
  354

1 row selected.