René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

q [Oracle's quote operator]

q'c text-to-be-quoted c'
c is a single character (called the quote delimiter). With the «quote operator» apostrophes don't have to be doubled: 
SQL> select q'#Oracle's quote operator#' from dual;

Q'#ORACLE'SQUOTEOPERATO
-----------------------
Oracle's quote operator