1       11:22:08  SQL Execute: ORACLE - select bmmc00,bmbh00 from vw_gy_gyxgks

2       11:22:08  SQL Execute: ORACLE - select a.*,'0' flag00 from vw_gy_wphs00 a where HSZT00='1' and hsksbh=75
 order by SQKSMC,SQRQ00||SQSJ00

3       11:22:08  SQL Execute: ORACLE - select HSDH00,WPBH00,WPMC00,WPXZMC,WPGG00,WPDW00,SQSL00,SQSL00 HSSL00,
DECODE(HSXZ00,0,'高压正常消毒',1,'高压过期消毒',2,'凡士林干热消毒') HSXZ00,
SCPH00,WSXKZH,MJPH00,YXQ000,SCCJBH,SCCJZW,GBH000,GCH000,PCLSH0,WPDJ00 
 from vw_gy_wphsmx where hsdh00='7' order by WPMC00,WPGG00,WPDW00 

4       11:22:08  SQL Execute: ORACLE - select WPMC00,WPBH00,WPXZMC,WPGG00,WPDW00,sum(nvl(SQSL00,0)) HSSL00 
 from VW_GY_WPHSMX where HSDH00= '7'  
 Group by WPMC00,WPBH00,WPXZMC,WPGG00,WPDW00 order by WPMC00,WPGG00,WPDW00

5       11:22:09  SQL Execute: ORACLE - select HSDH00,WPBH00,WPMC00,WPXZMC,WPGG00,WPDW00,SQSL00,SQSL00 HSSL00,
DECODE(HSXZ00,0,'高压正常消毒',1,'高压过期消毒',2,'凡士林干热消毒') HSXZ00,
SCPH00,WSXKZH,MJPH00,YXQ000,SCCJBH,SCCJZW,GBH000,GCH000,PCLSH0,WPDJ00 
 from vw_gy_wphsmx where hsdh00='7' order by WPMC00,WPGG00,WPDW00 

6       11:22:09  SQL Execute: ORACLE - select HSDH00,WPBH00,WPMC00,WPXZMC,WPGG00,WPDW00,SQSL00,SQSL00 HSSL00,
DECODE(HSXZ00,0,'高压正常消毒',1,'高压过期消毒',2,'凡士林干热消毒') HSXZ00,
SCPH00,WSXKZH,MJPH00,YXQ000,SCCJBH,SCCJZW,GBH000,GCH000,PCLSH0,WPDJ00 
 from vw_gy_wphsmx where hsdh00='243' order by WPMC00,WPGG00,WPDW00 

7       11:22:10  SQL Execute: ORACLE - select HSDH00,WPBH00,WPMC00,WPXZMC,WPGG00,WPDW00,SQSL00,SQSL00 HSSL00,
DECODE(HSXZ00,0,'高压正常消毒',1,'高压过期消毒',2,'凡士林干热消毒') HSXZ00,
SCPH00,WSXKZH,MJPH00,YXQ000,SCCJBH,SCCJZW,GBH000,GCH000,PCLSH0,WPDJ00 
 from vw_gy_wphsmx where hsdh00='243'
 and PCLSH0=

8       11:22:10  SQL Data In: ORACLE - Rows affected = 0