z261401120
凭栏觅影
2017-03-28 01:52

oracle执行sql报错03113

  • oracle
  • select

ORACLE下执行下面的sql报错,错误code03113,求大神指点原因
select * from ( select * from ORG_GROUP2 where LOGICDELETE = '0'
AND PROVINCEID = 'organization'

AND USERGROUPCODE LIKE (select USERGROUPCODE
FROM ORG_GROUP2 WHERE GROUP_UUID = '2873e6c4ac2f412a8d4b5b1bacd0cedd')||'%'

AND GROUP_UUID != '2873e6c4ac2f412a8d4b5b1bacd0cedd'

ORDER BY DISPLAYORDER,GROUP_UUID ) where rownum <= 10;

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

1条回答