ORA-01756:括号内的字符串没有正确结束

ORA-01756:括号内的字符串没有正确结束

ERROR: ORA-01756: quoted string not properly terminated

Evaluate the following SQL statement: SELECT product_name || 'it's not

available for order' FROM product_information WHERE product_status

 = 'obsolete'; You received the following error while executing the above query:

ERROR: ORA-01756: quoted string not properly terminated What would you do

to execute the query successfully?

1.在字符串单引号处再加一个单引号

product_name || 'it's not available for order' --改为product_name || 'it's not available for order'

如果字符中包括了单引号，就在该单引号处使用两个单引号；如果字符中出现了双引号，就直接在字符中使用双引号。

2、使用“q-quote写法”

product_name || 'it's not available for order' --改为product_name || q''

Use Quote (q) operator and delimiter to allow the use of single quotation mark in the literal character string.

3、使用“chr(39)写法”

product_name || 'it's not available for order' --改为product_name || ‘ it'||chr(39)||'s not available for order'

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9537053/viewspace-746099/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9537053/viewspace-746099/