title: Oracle Query with "&" special character
body: <p>I have an Oracle query that is blowing up when I have an "&amp;D" in the where statement</p>
  
  <pre><code>select &lt;field&gt; from &lt;table&gt; where field = 'ABC&amp;D';
  </code></pre>
  
  <p>The Oracle Variable window pops up asking for a value for :D.</p>
  
  <p>Any ideas?</p>