my_var:='This isn''t the string you''re looking for';
Notice how there are consecutive single quotes for the word "isn't" and "don't". Without these, you will get the error you have received.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.