The Q-quote mechanism

SQL> select q'(name LIKE '%DBMS_%%')'

2 from dual

3 /

Q'(NAMELIKE'%DBMS_%%

--------------------

name LIKE '%DBMS_%%'

SQL> select q'<'Data,' he said, 'Make it so.'>'

2 from dual

3 /

Q'<'DATA,'HESAID,'MAKEITSO.'>'

------------------------------

'Data,' he said, 'Make it so.'

SQL> select q'"name like '['"'

2 from dual

3 /

Q'"NAMELIKE'[

-------------

name like '['