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');
将;去掉即可