count函数与order by子句一起查询时报错处理

数据库版本: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';


请使用浏览器的分享功能分享到微信等