凭栏觅影
2017-03-28 01:52oracle执行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条回答
为你推荐
- Oracle使用存储过程怎么判断查询的记录是否存在?
- sql
- oracle
- java
- mysql
- 1个回答
- 在Oracle PL/SQL中创建数据包,遇到报错:PLS-00103:出现符号“CREATE”,请问如何解决?
- oracle
- 1个回答
- windows server2008 64位安装Oracle11g时 点击setup.exe 后 到 dos界面过后闪退!
- sql
- oracle
- 1个回答
- ORACLE存储过程遇到不合规数据跳过记录到日志然后继续插入合规数据
- sql
- oracle
- 1个回答
- 请问大侠们 python 执行SQL时报SyntaxError: EOL while scanning string literal该怎么解决,在线等,急...
- python
- sql
- oracle
- 1个回答
换一换