---------------------------------- Timestamp: 14:40:04.596 select a.ckmc00 YSCKMC,a.ckbh00 YSCKBH,b.sckbh0 fztbh0,c.ckmc00 fztmc0,d.bmbh00 fztbm0,e.bmmc00 fzbmmc from bm_ckbm00 a,bm_ckdy00 b,bm_ckbm00 c,bm_ckbm00 d, bm_bmbm00 e where b.sckbh0=c.ckbh00 and a.ckbh00=b.dckbh0 and b.sckbh0=d.ckbh00 and d.bmbh00=e.bmbh00 and a.ckbh00= (select ghhzck from sf_ysghhb where ghysbh=2 AND GHMZSJ=TO_CHAR(SYSDATE,'YYYYMMDD') AND GHMZSJ=TO_CHAR(SYSDATE,'YYYYMMDD') AND GHQSSJTO_CHAR(SYSDATE,'HH24:MI:SS')) Execution time: 0 ms Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号) ---------------------------------- Timestamp: 14:40:04.637 select a.ckmc00 YSCKMC,a.ckbh00 YSCKBH,b.sckbh0 fztbh0,c.ckmc00 fztmc0,d.bmbh00 fztbm0,e.bmmc00 fzbmmc from bm_ckbm00 a,bm_ckdy00 b,bm_ckbm00 c,bm_ckbm00 d, bm_bmbm00 e where b.sckbh0=c.ckbh00 and a.ckbh00=b.dckbh0 and b.sckbh0=d.ckbh00 and d.bmbh00=e.bmbh00 and a.ckbh00= (select ghhzck from sf_ysghhb where ghysbh=2 AND GHMZSJ=TO_CHAR(SYSDATE,'YYYYMMDD') AND GHMZSJ=TO_CHAR(SYSDATE,'YYYYMMDD') AND GHQSSJTO_CHAR(SYSDATE,'HH24:MI:SS')) Execution time: 0 ms ---------------------------------- Timestamp: 14:40:04.679 SELECT * FROM VW_YS_XXJLYS WHERE YSYGBH=2 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') order by FSSJ00 Execution time: 0 ms Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号) ---------------------------------- Timestamp: 14:40:04.723 SELECT * FROM VW_YS_XXJLYS WHERE YSYGBH=2 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') order by FSSJ00 Execution time: 0 ms ---------------------------------- Timestamp: 14:40:05.595 SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE YSYGBH=2 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='1' Execution time: 0 ms Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号) ---------------------------------- Timestamp: 14:40:05.660 SELECT COUNT(1) COUNT0 FROM YS_XXJL00 WHERE YSYGBH=2 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') AND SFLL00='0' AND BZ0000='1' Execution time: 0 ms ---------------------------------- Timestamp: 14:40:07.583 SELECT * FROM VW_YS_XXJLYS WHERE YSYGBH=2 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') order by FSSJ00 Execution time: 0 ms Runtime error occurred: 1036 (ORA-01036: 非法的变量名/编号) ---------------------------------- Timestamp: 14:40:07.647 SELECT * FROM VW_YS_XXJLYS WHERE YSYGBH=2 AND FSRQ00=TO_CHAR(SYSDATE,'YYYYMMDD') order by FSSJ00 Execution time: 0 ms