报错图片如下:
将打印的代码复制到plsql中运行了一下,发现是能取到数据的,并不会报错!
代码如下:
select b.id, b.is_valid, c.app_id system_id, c.app_name system_name, e.att_path as app_serh_id from ( select * from SGWPDM_SYS_USER_SYSTEM a where a.user_id = 'B2D16654E09D455EA3F257DF57BEBFB4' ) b, SGCIS_DEV_ALLY_APP c, SGCIS_DEV_ALLY_APP_PUBISH d, t_Mx_Attachment e, SGCIS_DEV_ALLY_APP_CLIENTTYPE f where b.system_id = c.app_id and b.system_id = d.app_id and d.icon_image_id = e.pk_val and d.publish_id = f.publish_id and f.dict_id in ('4028abf4722743d4017227596b8f9032','4028abf4722743d4017227596b8f9029');
最后发现是不能够在sql语句末尾添加