1       15:37:09  SQL Stmt: ORACLE - Reset
2       15:37:09  SQL Stmt: ORACLE - Close
3       15:37:09  SQL Prepare: ORACLE - SELECT 0 FPXMID,'总计' XMMC00,0 SFXMID,ROUND(SUM(HJJE00),2) HJJE00,ROUND(SUM(ZHJE00),2) ZHJE00, '' SL0000,'' DJ0000,ROUND(SUM(ZHJE00)/SUM(HJJE00),2)*100 ZKL000 FROM TJ_DWSFTJ WHERE ZHJE00 <> 0 AND SFXMID<>-1 AND DWID00='1602' UNION SELECT FPXMID,FPXMMC XMMC00,-1 SFXMID,SUM(HJJE00),SUM(ZHJE00),'' SL0000,'' DJ0000,ROUND(SUM(ZHJE00)/SUM(HJJE00),2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE ZHJE00 <> 0 AND HJJE00<>0 AND SFXMID<>-1 AND DWID00='1602' GROUP BY FPXMID,FPXMMC UNION SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000) SL0000,TO_CHAR(ROUND(HJJE00/SL0000,3)) DJ0000,ROUND(ZHJE00/HJJE00,2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE ZHJE00 <> 0 AND HJJE00<>0 AND SFXMID<>-1 AND DWID00='1602' ORDER BY FPXMID,SFXMID

4       15:37:09  SQL Execute: ORACLE - SELECT 0 FPXMID,'总计' XMMC00,0 SFXMID,ROUND(SUM(HJJE00),2) HJJE00,ROUND(SUM(ZHJE00),2) ZHJE00, '' SL0000,'' DJ0000,ROUND(SUM(ZHJE00)/SUM(HJJE00),2)*100 ZKL000 FROM TJ_DWSFTJ WHERE ZHJE00 <> 0 AND SFXMID<>-1 AND DWID00='1602' UNION SELECT FPXMID,FPXMMC XMMC00,-1 SFXMID,SUM(HJJE00),SUM(ZHJE00),'' SL0000,'' DJ0000,ROUND(SUM(ZHJE00)/SUM(HJJE00),2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE ZHJE00 <> 0 AND HJJE00<>0 AND SFXMID<>-1 AND DWID00='1602' GROUP BY FPXMID,FPXMMC UNION SELECT FPXMID,SFXMMC XMMC00,SFXMID,HJJE00,ZHJE00,TO_CHAR(SL0000) SL0000,TO_CHAR(ROUND(HJJE00/SL0000,3)) DJ0000,ROUND(ZHJE00/HJJE00,2)*100 ZKL000 FROM VW_TJ_DWSFTJ WHERE ZHJE00 <> 0 AND HJJE00<>0 AND SFXMID<>-1 AND DWID00='1602' ORDER BY FPXMID,SFXMID

5       15:37:09  SQL Error: ORACLE - ORA-01476: 除数为 0

6       15:37:09  SQL Error: ORACLE - Unmapped SQL Error Code: 1476
7       15:37:09  SQL Stmt: ORACLE - Reset
8       15:37:09  SQL Data In: ORACLE - Rows affected = 0
9       15:37:09  SQL Stmt: ORACLE - Close