一次ORA-03113错误解决(三)
a.billtype,
13:08:55 21 a.billid,fun_getbillremark(a.billid) remark,fun_getbilloriginbillid(a.b
illid) originbillid,
13:08:55 22 a.otherinouttype,
13:08:55 23 a.shopcode,
13:08:55 24 a.storecode,
13:08:55 25 a.goodscode,
13:08:55 26 c.shortcode,c.brandcode,c.model,
13:08:55 27 c.goodsname,
13:08:55 28 sum(DECODE(b.ruleid,1,a.realnumber,2,-a.realnumber,0)) irealnumber,
13:08:55 29 sum(DECODE(b.ruleid,1,
13:08:55 30 round(a.realnumber * a.price,2),
13:08:55 31 2,
13:08:55 32 round(-1 * a.realnumber *a.price,2),
13:08:55 33 0)) imoney,
13:08:55 34 sum(DECODE(b.ruleid,2,a.realnumber,1,-a.realnumber,0)) orealnumber,
13:08:55 35 sum(decode(b.ruleid,2,
13:08:55 36 round(a.realnumber * a.price,2),
13:08:55 37 1,
13:08:55 38 round(-1 * a.realnumber * a.price,2),
13:08:55 39 0)) omoney
13:08:55 40 from t_storeout a, t_billlist b,t_goods c
13:08:55 41 where a.billtype = b.billtype
13:08:55 42 and a.goodscode=c.goodscode and (a.shopcode = '0603')
13:08:55 43 group by a.operatetime,
13:08:55 44 a.billtype,
13:08:55 45 a.billid,
13:08:55 46 remark,
13:08:55 47 a.otherinouttype,
13:08:55 48 a.shopcode,
13:08:55 49 a.storecode,
13:08:55 50 a.goodscode,
13:08:55 51 c.shortcode,
13:08:55 52 c.goodsname,c.brandcode,c.model
13:08:55 53 ) x
13:08:55 54 where x.billtype in (select billtype from t_billlist where ruleid>0) and
13:08:55 55 x.operatetime >= to_date('2013-6-17','YYYY-MM-DD')
13:08:55 56 and x.operatetime < to_date('2013-6-18','YYYY-MM-DD')
13:08:55 57 ) a group by operatetime,billtypename,billid,shopcode,shopname,goodscode,goodsname or
der by operatetime,billtypename,billid,shopcode,shopname,goodscode,goodsname;
未选定行
已用时间: 00: 00: 00.04