select operatetime,billtypename,billid,shopcode,shopname,goodscode,goodsname,' ' 期初数量,sum(irealn
umber) irealnumber,DECODE(sum(irealnumber),0,0,round(sum(imoney)/sum(irealnumber),2)) iprice,sum(imo
ney) imoney,sum(orealnumber) orealnumber,DECODE(sum(orealnumber),0,0,round(sum(omoney)/sum(orealnumb
er),2)) oprice,sum(omoney) omoney,' ' 结存数量 from( select to_char(x.operatetime, 'YYYY-MM-DD') ope
ratetime,x.billtype,
*
第 1 行出现错误:
ORA-03113: 通信通道的文件结尾
进程 ID: 20027
会话 ID: 201 序列号: 149
已用时间: 00: 00: 02.01
精简改SQL如下后报ORA-600错误:
13:07:18 CRY@CRY> SELECT operatetime
13:07:19 2 FROM (SELECT to_char(x.operatetime, 'YYYY-MM-DD') operatetime
13:07:19 3 FROM (SELECT operatetime FROM t_storeout GROUP BY operatetime) x
13:07:19 4 WHERE x.operatetime > to_date('2012-01-01', 'YYYY-MM-DD')) a
13:07:19 5 GROUP BY operatetime;
FROM (SELECT operatetime FROM t_storeout GROUP BY operatetime) x
*
第 3 行出现错误:
ORA-00600: 内部错误代码, 参数: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []
已用时间: 00: 00: 01.68