title: Remove template text on regexp_replace in Oracle's SQL
body: <p>I am trying to remove template text like &amp;#x; or &amp;#xx; or &amp;#xxx; from long string</p>
  <p>Note: x / xx / xxx - is number, The length of the number is unknown, The cell type is CLOB</p>
  <p>for example:</p>
  <pre><code>SELECT 'H&amp;#39;ello wor&amp;#177;ld' FROM dual
  </code></pre>
  <p>A desirable result:</p>
  <pre><code>Hello world
  </code></pre>
  <p>I know that <strong>regexp_replace</strong> should be used, But how do you use this function to remove this text?</p>