title: HTML encoding in SQL
body: <p>I have a requirement where I have to encode/decode a string having special characters or symbols in SQL to its HTML equivalent values. 
  Have tried with utl_i18n.escape_reference or utl_i18n.unescape_reference but it does not work for all characters or sysmbols. Below is such example:</p>
  
  <pre><code>select utl_i18n.escape_reference('REGIONS BANK Ó MORTGAGE Û') from dual;
  </code></pre>
  
  <p>Expected Output---- <code>REGIONS BANK &amp;Oacute; MORTGAGE &amp;Ucirc;</code><br>
  Output Got --- <code>REGIONS BANK Ó MORTGAGE Û</code></p>
  
  <p>The unescape is working if i pass the text as </p>
  
  <pre><code>REGIONS BANK &amp;Oacute; MORTGAGE &amp;Ucirc;
  </code></pre>
  
  <p>Are there any other utilities that I can use for the same?</p>