ORA-00911: 无效字符的错误

我把SQL打到控制台上面,然后COPY到SQL PULS中是可以查询数据的,

但是在ECLIPSE中执行就报ORA-00911: 无效字符的错误,

select pm.* from PM_DECISION_RESULTS pm,lc_appl lc where lc.appl_cde = pm.applicationnumber and lc.appl_cde = (select appl_cde from lc_appl l where l.appl_seq = ${appl_seq} )and pm.system_decision in ('P','N');
将;去掉即可

 

posted @ 2017-08-25 17:24  影子影  阅读(417)  评论(0编辑  收藏  举报