title: Oracle SQL escape character (for a '&')
body: <p>While attempting to execute SQL insert statements using <a href="http://www.oracle.com/technology/products/database/sql_developer/index.html" rel="noreferrer">Oracle SQL Developer</a> I keep generating an "Enter substitution value" prompt:</p>
  
  <pre><code>insert into agregadores_agregadores 
  (
   idagregador,
   nombre,
   url
  ) 
  values 
  (
   2,
   'Netvibes',
   'http://www.netvibes.com/subscribe.php?type=rss\&amp;amp;url='
  );
  </code></pre>
  
  <p>I've tried <a href="http://download.oracle.com/docs/cd/B10501_01/text.920/a96518/cqspcl.htm" rel="noreferrer">escaping the special character in the query</a> using the '\' above but I still can't avoid the ampersand, '&amp;', causing a string substitution.</p>