Oracle provides standard functions, converts the character set name and ID SQL> SELECT NLS_CHARSET_ID ('zHS16GBK') from dual; nls_charset_id ('zhs16gbk') ------------------- -------- 8521 ROW SELECTED.SQL> SELECT NLS_CHARSET_NAME (852) from dual; nls_char -------- zhs16gbk1 row selected. Decimal conversion hexadecimal: SQL> SELECT TO_CHAR ('852', 'xxxx') from dual; to_ch ----- 3541 row successd.
