title: & IN WHERE CLAUSE of oracle
body: <p>I had SQL query running on SQL developer IDE:</p>
  
  <pre><code>SELECT IC.ID 
  FROM INSTITUTE_COURSE IC 
  WHERE IC.NAME = 'CIVIL &amp; ARCHITECTURE CAD';
  </code></pre>
  
  <p>Due to <code>&amp;</code> in where clause, ide returns an error <code>"Enter Substitution Variable".</code></p>
  
  <p>If I remove <code>&amp;</code> in String, query runs fine.</p>
  
  <p><strong>My Question is how to run query with &amp;/ampersand in where clause?</strong></p>