Oracle q-quote (Quoting Character Literals)

By default you must quote character literals in single-quotes, as in 'Hello'. This technique can sometimes be inconvenient if the text itself contains single quotes. Oracle 10g allows you to define your own string delimiters to remove the need to double up any single quotes. Any character that is not present in the string can be used as the delimiter. The Q-quote mechanism, which enables you to specify q or Q followed by a single quote and then another character to be used as the quote delimiter.