博客内容涉及一个Oracle SQL查询的问题，该查询在使用子查询和连接操作时出现'EO.ENTITY_ID'无效的标识符错误。当用具体值替换变量时，查询能够正常运行。查询涉及到ENTITY_OWNERSHIPEO表和ENTITY_OWNERSHIP表的关联，以及通过USER_ID和GROUP_ID的交集来过滤结果。
为什么下面的查询在oracle中不起作用？
select * from ENTITY_OWNERSHIP EO
where
(select count (*)
from (
select USER_ID
from ENTITY_OWNERSHIP
where ENTITY_OWNERSHIP.ENTITY_ID = EO.ENTITY_ID
)
) > 0
它产生“ORA-00904：”EO“.”ENTITY_ID“：无效的标识符”.但是当我用精确值替换EO.ENTITY_ID时,例如,10181然后它可以工作.
更新：
完整查询如下所示：
select * from ENTITY_OWNERSHIP EO
where
(select count (*)
from (
select USER_ID
from ENTITY_OWNERSHIP
where ENTITY_OWNERSHIP.ENTITY_ID = EO.ENTITY_ID
intersect
select distinct group_id
from USERS.GROUPS
start with GROUP_ID in (select GROUP_ID from USERS.LK_GROUPS where USER_ID=10001)
connect by prior PARENTGROUP_ID=GROUP_ID
)
) > 0
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
