exists出现的错误：ora-03113 通信通道的文件结束

使用这样没问题select a.ID
  from system_menu_info a
 where a.IS_ACTIVE = 1
   and exists ( select  *
          from SYSTEM_ROLE_MENU_RELATION b
          left outer join SYSTEM_ROLE_USER_RELATION c on c.ROLE_ID =
                                                         b.ROLE_ID
         where c.USER_ID = 1
              and b.menu_id=a.id
         )
   and trim(a.PARENT_ID) is null

这样就

GOOGLE时看到了这句话：IN适合于外表大而内表小的情况；EXISTS适合于外表小而内表大的情况