Oracle Q-quote delimiter

The Q-quote delimiter can be any single or multibyte character except space, tab, and return.

If the opening quote delimiter is a [, {, <, ( character, then the closing quote delimiter must be the corresponding ], }, >, ) character.

In all other cases, the opening and closing delimiter must be the identical character. for example !,#,|.

从10g开始引入该特性。q'后面的字符可以是下面这些配对的或者其他自己指定的符号，我们常用的有 ！# |,前提是这些字符不会出现在后续的SQL中。

•     [ ]
•     { }
•     ( )
•     < >