Use of quote in Oracle

Use of quote in Oracle

To express a special character string in SQL or PLSQL, it is usually packaged. However, if the string itself contains characters like 'or', the implementation is a little complicated.

For example, My Name is "Wang Xiu Li"

Implement with SQL

SQL> select 'My Name is "Wang Xiu Li" 'names from dual;

NAMES
------------------------
My Name is "Wang Xiu Li"

Oracle provides a Q-quote expression to simplify the expression of strings in SQL or PLSQL.

SQL> select Q' [My Name is "Wang Xiu Li"] 'names from dual;

NAMES
------------------------
My Name is "Wang Xiu Li"

Note Syntax: the strings to be expressed must be enclosed by a special character, which must be consistent.