oracle中有字符编码和解码的函数，用了一下，真的很好。编码：utl_url.escape ，解码：utl_url.

举例如下：

create or replace  function encodeStr(str1 in varchar2,strCode in varchar2) return varchar2
is
ss varchar2(100);
  begin
  ss :=   utl_url.escape(str1, true, strCode);
  return ss;
end;

select encodeStr('祝您旅途平安','gb2312' )  d  from dual

解码：utl_url.

例如：select utl_url.('https://www.abc.com/日太阳/','UTF-8') from dual;

UTL_URL.('HTTPS://WWW.                                                 
---------------------------------------------------------------------