2020-12-30
执行sql报错ora00600 -19004版本11.2.0.4实在没研究明白,求大神帮忙!
10M执行sql报错ora00600 -19004版本11.2.0.4实在没研究明白,求大神帮忙!
SQL文如下:
select count(DISTINCT(X.ID)) userNum
FROM T_USERINFO X, CYL_ORG Y, CYL_MEMBER Z
WHERE Y.ORG_CODE = Z.ORG_CODE
AND X.ID = Z.USER_ID
AND X.ID IN
(SELECT m.USER_ID
FROM DJ_USER_ORG_ROLE m
INNER JOIN DJ_AUTH_ROLE n
ON m.ROLE_ID = n.ID
WHERE n.ROLE_NAME IN (‘普通团员’)
AND n.BIZ_TYPE = ‘1’
AND m.ORG_ID in
(select t.id from cyl_org t where t.org_code like ‘002.001.999%’))
and Y.ORG_CODE like ‘002.001.999%’
and Z.ORG_CODE like ‘002.001.999%’
AND X.IS_DELETE = ‘0’
AND Y.IS_DELETE = ‘0’
AND Z.IS_DELETE = ‘0’
我来答
添加附件
收藏
分享
问题补充
1条回答
默认
最新
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

评论
