Oracle 转义HTML特殊字符

For example, you can use the htf.escape_sc function:

SQL> select htf.escape_sc('Please escape <this> tag') from dual;
HTF.ESCAPE_SC('PLEASEESCAPE<THIS>TAG')
------------------------------------------------------------------
Please escape <this> tag

1. htf.escape_sc

This replaces characters that have special meaning in HTML with their escape sequences. The following characters are converted:

& to &amp; " to &quot: < to &lt; > to &gt;

The procedure version of this subprogram does the same thing as htp.prints and htp.ps.

Properties	Definitions
Syntax:	htf.escape_sc(ctext in varchar2) return varchar2; htp.escape_sc(ctext in varchar2);
Parameters:	ctext - the string to convert.
Generates:	The converted string.

2.  htf.escape_url

This replaces characters that have special meaning in HTML and HTTP with their escape sequences. The following characters are converted: & to &amp; " to &quot; < to &lt; > to &gt; % to %25

Properties	Definitions
Syntax:	htf.escape_url(p_url in varchar2) return varchar2;
Parameters:	p_url - the string to convert.
Generates:	The converted string.

转载自：https://sites.google.com/site/oracleworkstation/blog/oraclehtfescapesc