title: How to enter special characters like "&" in oracle database?
body: <p>I want to insert special character <code>&amp;</code> in my insert statement. My insert is:</p>
  
  <pre><code>INSERT INTO STUDENT(name, class_id) VALUES ('Samantha', 'Java_22 &amp; Oracle_14');
  </code></pre>
  
  <p>If I try to run this query I am getting a popup and it asks me to enter value for <code>Oracle_14</code>. </p>
  
  <p>How can I enter special characters like <code>&amp;</code> in the insert statement for oracle db?</p>