1       08:47:35  SQL Execute: ORACLE - select '1' SFCG00,D.YPMC00,D.YPGG00,A.MRCGSL,A.MRCGSL||D.KCDW00 YFCGXL,sum(nvl(B.JHCGSL,0)*B.ZHL000/D.K2J000)||D.KCDW00 YCGSL0,
 decode(sign(A.MRCGSL-sum(nvl(B.JHCGSL,0)*B.ZHL000/D.K2J000)),1,substr(A.MRCGSL-sum(nvl(B.JHCGSL,0)*B.ZHL000/D.K2J000)||D.KCDW00,1,50),0,0,'') KCGSL0,
 decode(sign(3 + sum(nvl(B.JHCGSL,0)*B.ZHL000/D.K2J000)-A.MRCGSL),1,substr(3 +sum(nvl(B.JHCGSL,0)*B.ZHL000/D.K2J000)-A.MRCGSL||D.KCDW00,1,50),'') CCCGSL
 from YK_YPKCXX A,YK_CGJHMX B,BM_YD0000 D,YK_YPCGJH C
 where A.YPNM00=B.YPNM00 and B.YPNM00=D.YPNM00 and B.CGJHDH=C.CGJHDH and A.YPNM00 = 9000000133 and A.YKBMBH=2279 
 and C.SFQR00='Y' and C.QRRQ00 between to_char(sysdate,'YYYYMM')||'01' and to_char(last_day(sysdate),'YYYYMMDD') 
 and nvl(A.MRCGSL,0)>0 group by A.MRCGSL,D.YPMC00,D.YPGG00,D.KCDW00 
 union all
 select '2' SFCG00,D.YPMC00,D.YPGG00,A.MRCGSL,A.MRCGSL||D.KCDW00 YFCGXL,'0' YCGSL0,A.MRCGSL||D.KCDW00 KCGSL0,3||D.KCDW00 CCCGSL
 from YK_YPKCXX A,BM_YD0000 D
 where A.YPNM00=D.YPNM00 and A.YKBMBH=2279 and A.YPNM00 = 9000000133 and nvl(A.MRCGSL,0)>0
 and A.YPNM00 not in (select B.YPNM00 from YK_CGJHMX B,YK_YPCGJH C where B.CGJHDH=C.CGJHDH and C.SFQR00='Y' and C.QRRQ00 between to_char(sysdate,'YYYYMM')||'01' and to_char(last_day(sysdate),'YYYYMMDD'))

2       08:47:35  SQL Execute: ORACLE - select '1' SFCG00,D.YPMC00,D.YPGG00,A.MRCGSL,A.MRCGSL||D.KCDW00 YFCGXL,sum(nvl(B.JHCGSL,0)*B.ZHL000/D.K2J000)||D.KCDW00 YCGSL0,
 decode(sign(A.MRCGSL-sum(nvl(B.JHCGSL,0)*B.ZHL000/D.K2J000)),1,substr(A.MRCGSL-sum(nvl(B.JHCGSL,0)*B.ZHL000/D.K2J000)||D.KCDW00,1,50),0,0,'') KCGSL0,
 decode(sign( + sum(nvl(B.JHCGSL,0)*B.ZHL000/D.K2J000)-A.MRCGSL),1,substr( +sum(nvl(B.JHCGSL,0)*B.ZHL000/D.K2J000)-A.MRCGSL||D.KCDW00,1,50),'') CCCGSL
 from YK_YPKCXX A,YK_CGJHMX B,BM_YD0000 D,YK_YPCGJH C
 where A.YPNM00=B.YPNM00 and B.YPNM00=D.YPNM00 and B.CGJHDH=C.CGJHDH and A.YPNM00 = 9000000371 and A.YKBMBH=2279 
 and C.SFQR00='Y' and C.QRRQ00 between to_char(sysdate,'YYYYMM')||'01' and to_char(last_day(sysdate),'YYYYMMDD') 
 and nvl(A.MRCGSL,0)>0 group by A.MRCGSL,D.YPMC00,D.YPGG00,D.KCDW00 
 union all
 select '2' SFCG00,D.YPMC00,D.YPGG00,A.MRCGSL,A.MRCGSL||D.KCDW00 YFCGXL,'0' YCGSL0,A.MRCGSL||D.KCDW00 KCGSL0,||D.KCDW00 CCCGSL
 from YK_YPKCXX A,BM_YD0000 D
 where A.YPNM00=D.YPNM00 and A.YKBMBH=2279 and A.YPNM00 = 9000000371 and nvl(A.MRCGSL,0)>0
 and A.YPNM00 not in (select B.YPNM00 from YK_CGJHMX B,YK_YPCGJH C where B.CGJHDH=C.CGJHDH and C.SFQR00='Y' and C.QRRQ00 between to_char(sysdate,'YYYYMM')||'01' and to_char(last_day(sysdate),'YYYYMMDD'))

3       08:47:35  SQL Error: ORACLE - ORA-00936: ȱʧ±í´ïʽ

4       08:47:35  SQL Error: ORACLE - Unmapped SQL Error Code: 936
5       08:47:35  SQL Data In: ORACLE - Rows affected = 0