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