数据库版本:12.2.0.1
语句:
SELECT count(*) FROM wuyang
WHERE name BETWEEN 'W1' AND 'W3' OR c1 BETWEEN 'W05' AND 'W07'
ORDER BY name;
ERROR at line 2:
ORA-03113: end-of-file on communication channel
Process ID: 78509
Session ID: 15 Serial number: 1785
alter日志报错:
ORA-7445 [kkoosoel]
将order by 语句去掉后,问题解决:
SELECT count(*) FROM wuyang
WHERE name BETWEEN 'W1' AND 'W3' OR c1 BETWEEN 'W05' AND 'W07';
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/70021989/viewspace-3006585/ ,如需转载,请注明出处,否则将追究法律责任。