title: How to escape & character in Oracle query
body: <pre><code> SELECT DISTINCT ENTRY_GUID FROM 
         (SELECT e.ENTRY_GUID FROM alertwlnqedv3.ENTRY e,
                                   alertwlnqedv3.ENTRY_PARTNERDEFINED_INFO ep,
                                   alertwlnqedv3.PRODUCT p
          WHERE e.ENTRY_GUID = ep.ENTRY_GUID AND 
                e.PRODUCT_CODE = p.PRODUCT_CODE AND
               (XMLEXISTS('/partnerDefinedInfo/facetedIds/alertGroup[text()=
               ("Colleen&amp;s Main Web2 QA Folder")]' PASSING PARTNERDEFINED_INFO) ) AND 
                e.STATUS_CODE != 13 AND 
                p.PRODUCT_VALUE =1)
  </code></pre>
  
  <p>Am trying to run the above query - where <code>Colleen&amp;s Main Web2 QA Folder</code> is the text entered on a run time. Now as it allows the special character <code>&amp;</code> the query is breaking. I tried to escape with \ and one more <code>&amp;</code> but still it fails. Please let me know how can I handle this scenario. TIA.</p>