utl_url.escape和utl_url.unescape

select utl_url.escape('https://www.abc.com/trade/gathering_index.htm?src=c_ guid_ to_new_01') from dual;
select utl_url.unescape('http%3A%2F%2Fab.abc.com%2Findex.htm%3FNummain%3D13%26seed%3D%E7%AE%80%E4%BB%8B','UTF8') from dual;