开发点滴:
做了这么久开发,第一次碰到这种问题,好好尴尬,报错图片如下:
将打印的代码复制到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语句末尾添加‘;’