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.
