z261401120
凭栏觅影
采纳率0%
2017-03-28 01:52 阅读 2.0k

oracle执行sql报错03113

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条回答 默认 最新

  • youcaihuahy Leon0720 2017-03-28 02:13

    select USERGROUPCODE
    FROM ORG_GROUP2 WHERE GROUP_UUID = '2873e6c4ac2f412a8d4b5b1bacd0cedd'
    这条语句一定要保证结果不是一个并且不能为空。
    另外报的错误应该和语句没有关系,是你的数据库的归档日志有问题。可以将数据库切换到非归档模式:
    http://www.cnblogs.com/xwdreamer/p/3910264.html

    点赞 评论 复制链接分享

相关推荐