数据库字符集修改函数function nls_charset_id_name

 
#提取utf8字符集的十六进制编码
SQL> select to_char(nls_charset_id('utf8'),'xxxx') from dual;
TO_CHAR(NL
----------
  367
 
 
#反向提取utf8字符集十六进制
SQL> select nls_charset_name(to_number('0367','xxxx')) from dual;
NLS_CHARSET_NAME(TO_NUMBER('0367','XXXX'))
--------------------------------------------------------------------------------
UTF8
SQL> select nls_charset_name(to_number('367','xxxx')) from dual;
NLS_CHARSET_NAME(TO_NUMBER('367','XXXX'))
--------------------------------------------------------------------------------
UTF8
请使用浏览器的分享功能分享到微信等