Original SQL:
An ORA-03113 error occurred while running, the network is normal, and other SQL statements are also normal.
13:04:26 CRY @ CRY> select operatetime, billtypename, billid, shopcode, shopname, goodscode, goodsn
Ame, ''quantity at the beginning of the period, sum (irealnumber) irealnumber, DECODE (sum (irealnumber), 0, 0, round (sum (imoney)/sum (irea
Lnumber), 2) iprice, sum (imoney) imoney, sum (orealnumber) orealnumber, DECODE (sum (orealnumber), 0, roun
D (sum (omoney)/sum (orealnumber), 2) oprice, sum (omoney) omoney, ''Number of balances from (select to_char (x. ope
Ratetime, 'yyyy-MM-DD ') operatetime, x. billtype,
13:04:28 2 fun_getname ('billtypeall', x. billtype) billtypename,
13:04:28 3 x. billid, x. remark, x. originbillid,
13:04:28 4 fun_getname ('operationtype', x. otherinouttype) otherinouttypename,
13:04:28 5 x. shopcode,
13:04:28 6 f_getOrganiseName (x. shopcode) shopname,
13:04:28 x. storecode,
13:04:28 8 f_getStoreName (x. storecode) storename,
13:04:28 9 FUN_GETTOUNIT (x. billtype, x. billid) unitname,
13:04:28 10 x. goodscode,
13:04:28 X. goodsname,
13:04:28 12 x. ShortCode, x. brandcode, x. model,
13:04:28 x. irealnumber,
13:04:28 14 abs (DECODE (x. irealnumber, round (x. imoney/x. irealnumber, 4) iprice,
13:04:28 15 x. imoney, x. orealnumber,
13:04:28 abs (DECODE (x. orealnumber, round (x. omoney/x. orealnumber, 4) oprice,
13:04:28 17 x. omoney
13:04:28 from (
13:04:28 19 select a. operatetime,
13:04:28 20 a. billtype,
13:04:28 21 a. billid, fun_getbillremark (a. billid) remark, fun_getbilloriginbillid (a. B
Illid) originbillid,
13:04:28 22 a. otherinouttype,
13:04:28 a. shopcode,
13:04:28 a. storecode,
13:04:28 a. goodscode,
13:04:28 26 c. release code, c. brandcode, c. model,
13:04:28 27 c. goodsname,
13:04:28 28 sum (DECODE (B. ruleid, 1, a. realnumber, 2,-a. realnumber, 0) irealnumber,
13:04:28 29 sum (DECODE (B. ruleid, 1,
13:04:28 round (a. realnumber * a. price, 2 ),
13:04:28 31 2,
13:04:28 32 round (-1 * a. realnumber * a. price, 2 ),
13:04:28 33 0) imoney,
13:04:28 34 sum (DECODE (B. ruleid, 2, a. realnumber, 1,-a. realnumber, 0) orealnumber,
13:04:28 35 sum (decode (B. ruleid, 2,
13:04:28 36 round (a. realnumber * a. price, 2 ),
13:04:28 37 1,
13:04:28 38 round (-1 * a. realnumber * a. price, 2 ),
13:04:28 39 0) omoney
13:04:28 40 from TAB_A a, TAB_ B B, TAB_C c
13:04:28 41 where a. billtype = B. billtype
13:04:28 42 and a. goodscode = c. goodscode and (a. shopcode = '20140901 ')
13:04:28 group by a. operatetime,
13:04:28 44 a. billtype,
13:04:28 a. billid,
13:04:28 46 remark,
13:04:28 47 a. otherinouttype,
13:04:28 48 a. shopcode,
13:04:28 49. a. storecode,
13:04:28 50 a. goodscode,
13:04:28 c. Postal code,
13:04:28 52 c. goodsname, c. brandcode, c. model
13:04:28) x
13:04:28 54 where x. billtype in (select billtype from t_billlist where ruleid> 0) and
13:04:28 55 x. operatetime> = to_date ('2017-6-17 ', 'yyyy-MM-DD ')
13:04:28 56 and x. operatetime <to_date ('2017-6-18 ', 'yyyy-MM-DD ')
13:04:28) a group by operatetime, billtypename, billid, shopcode, shopname, goodscode, goodsname or
Der by operatetime, billtypename, billid, shopcode, shopname, goodscode, goodsname;
Select operatetime, billtypename, billid, shopcode, shopname, goodscode, goodsname, ''initial quantity, sum (irealn
Umber) irealnumber, DECODE (sum (irealnumber), 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, ''Number of balances from (select to_char (x. operatetime, 'yyyy-MM-DD ') ope
Ratetime, x. billtype,
*
Row 3 has an error:
ORA-03113: End of the file for the communication channel
Process ID 20027
Session ID: 201 serial number: 149
ERROR:
ORA-03114: not connected to Oracle
Used time: 00: 00: 02.01
A ORA-600 error is reported after the SQL statement is simplified as follows:
13:07:18 CRY @ CRY> SELECT operatetime
13:07:19 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 ('2017-01-01 ', 'yyyy-MM-DD')
13:07:19 group by operatetime;
FROM (SELECT operatetime FROM t_storeout group by operatetime) x
*
Row 3 has an error:
ORA-00600: Internal error code, parameter: [rwoirw: check ret val], [], [], [], [], [], [], [], [], [], [], []
Used time: 00: 00: 01.68