ORA-01756: 括号内的字符串没有正确结束 这是什么错？我的select语句运行时都是正确的呀

[galepeng]

select t.item_code,t.item_name
from lis.advice_content_person w,
(select item_code, item_name
from hisdict.price_dict
where item_code in
(select item_code
from hisdict.advice_both_fee_dict
where advice_code in
(select advice_code
from hisdict.advice_static_dict
where class_code ='D')))t
where w.check_id=t.item_code
and w.doctor_id='0000001'

[jiezhi]

看起來是對的。你在sqlplus里面執行出錯嘛？

[black_snail]

怀疑'是不是用中文打的
....
只是怀疑而已,因为俺犯过这样的错

[beckhambobo]

select t.item_code,t.item_name
from lis.advice_content_person w,
(select item_code, item_name
from hisdict.price_dict b
where exists(select 1 from hisdict.advice_both_fee_dict a
where item_code=b.item_code and exists(select 1 from hisdict.advice_static_dict where a,advice_code=advice_code and class_code ='D'))) t where w.check_id=t.item_code
and w.doctor_id='0000001'

[chanet]

本来是进来看问题的，但看见好多星星呀... :)
试试用 ed 编辑一下，再运行。

在 SqlPlus 有时在有许多字符换行时，有误判。