q'转义
功能描述
q'转义功能用来对包含特殊字符的字符串进行转义。
q'转义符通常后面使用!! [] {} () <> \\转义符号（转义符需成对出现）。
语法格式
q'转义符 expr 转义符参数说明
expr：待转义字符串。
示例
sql
SQL> SELECT q'[it's an example1]' FROM dual;
EXPR1 |
------------------------------------------------------------------------------
it's an example1|
SQL> SELECT q'{it's an example2}' FROM dual;
EXPR1 |
------------------------------------------------------------------------------
it's an example2|
SQL> SELECT q'(it's an example3)' FROM dual;
EXPR1 |
------------------------------------------------------------------------------
it's an example3|
SQL> SELECT q'<it's an example4>' FROM dual;
EXPR1 |
------------------------------------------------------------------------------
it's an example4|
SQL> SELECT q'\it's an example5\' FROM dual;
EXPR1 |
------------------------------------------------------------------------------
it's an example5|
SQL> SELECT q'!it's an example6!' FROM dual;
EXPR1 |
------------------------------------------------------------------------------
it's an example6|