PLSQL quotes and double quotes

[Quoted] This is a very simple question: How do we embedded single quotes in single quotes when assigning a stringg to a variable ?.

Ex:

string1 VARCHAR2(100) := 'select column1 from table1 where column2 = '5' and column3 is null';

Chris Received on Fri May 16 1997 - 00:00:00 CEST