title: How to handle special characters in query strings?
body: <p>I am writing a query like</p>
  
  <pre><code>select * from fact_table where name = 'R&amp;D'
  
  select * from fact_table where name = 'John's'
  </code></pre>
  
  <p>I am using oracle 11g database. Is there any generic function or query style where in I can handle special characters like '&amp;' and ''' in my query.</p>
  
  <p>I do not want to handle each case seperately, i want a generic mechanism.</p>
  
  <p>If this is a duplicate post please guide me to the original post</p>