How to escape single quotes in Oracle? [duplicate]

Question

I have a column containing certain expressions stored as a text string which include single quotatons, such as 'missed transaction' (INCLUDING the quotations)

How can I use a where clause with such an occurance?

select * from table where reason = ''missed transaction''

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.

Answer 1

You need to escape the ' by doubling them :

select * from table where reason = '''missed transaction''';