title: How to escape single quotes in Oracle?
body: <p>I have a column containing certain expressions stored as a text string which include single quotatons, such as 'missed transaction' (INCLUDING the quotations) </p>
  
  <p>How can I use a where clause with such an occurance?</p>
  
  <p><code>select * from table where reason = ''missed transaction''</code> </p>
  
  <p>doesn't work, and I can't use the replace function because it also requires single quotations in its syntax. Obscure problem, i know. But thanks for any help.</p>