title: HTML Entity decoding to Special characters
body: <p>I want to display special symbols in my output.
  For eg: My text may contain entity codes like <code>&amp;lt;</code>, <code>&amp;gt</code>; etc.
  I want to display this as <code>&lt;</code>, <code>&gt;</code> in my output. I need to do this in SQL.
  I googled about this and got a function,</p>
  
  <p><code>select dbms_xmlgen.convert('ABC &lt;; ',0) from dual</code></p>
  
  <p>This does the reverse process, it generates the output as 'ABC &lt;'</p>
  
  <p>I tried with decoding but it does not work. I even changed the sql command as,
  <code>select dbms_xmlgen.convert('ABC &lt;; ',1) from dual</code>, where 1 is for <code>entity_decode</code>, but I don't get the desired output.</p>