ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-01756:括号内的字符串没有正确结束

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

原创 Linux操作系统 作者:treesofthehill 时间:2012-10-10 17:25:24 0 删除 编辑

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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-06-11

  • 博文量
    97
  • 访问量
    179380