title: unable to execue the following select statement getting error
body: <p>when i execute the following select statement i am getting the below error.</p>
  
  <p>I am trying to execute the below statement in Oracle server 9.1.</p>
  
  <p>I believe due to this i am getting this error. </p>
  
  <p>I know we can excute the query for single quotes by '%Blondeau D''Uva%'. But i am looking for query which will pass the special character value as parameter.</p>
  
  <p>Kindluy let me know how to escape single quotes in old oracle server</p>
  
  <p>ERROR : </p>
  
  <pre><code>  ORA-00933: SQL Command not properly ended
  Error at line : 1 Column : 50
  </code></pre>
  
  <p>Query:</p>
  
  <pre><code>Select * FROM TABLEA where UI_FNAME like q'[%Michael%]' and UI_LNAME  like q'[ %Blondeau D'Uva%]';
  </code></pre>