1       09:14:54  Log started for: SQL Navigator for Oracle
2       15:27:58  Log started for: 住院医生工作站系统
3       15:29:46  SQL Execute: ORACLE - SELECT XH0000,XTDM00,CZYKSM,CZRQ00,XXNR00,XXNR01 FROM vw_ht_xttsxx a 
where yxq000 >= TO_CHAR (SYSDATE, 'YYYYMMDD')
 and (XXXZ00 in('0','1') and (xtdm00 = '-1' OR xtdm00 = 'Z') )
 and (JSKSBH IS NULL OR INSTR(','||jsksbh||',', ',74,')> 0)
 and (JSRY00 IS NULL OR INSTR(','||JSRY00||',', ',1,')> 0)
 AND NOT EXISTS (SELECT 1 FROM xt_yhxxrz b WHERE b.xh0000 = a.xh0000 AND JSYGBH =1 AND b.JSKSBH = '74')
  AND (INSTR (',' || a.jsksbh || ',',',74,') > 0 or a.jsksbh is null)  

4       15:29:47  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = %xxbfx%
5       15:29:47  SQL Execute: ORACLE - Select * from (select ZLXMJC,ZLXMID,DW0000,ZLXMBH,PYSM00,WBSM00,SFJE00,YBLBMC,ZFBL00,LBBH00,NBLBMC,NBZFBL,XMZHSM from VW_BQ_FBFYYZ where (PYSM00 Like ?) and(  (FYID00=rpad('0',6,' ') or FYID00=rpad('223510',6,' '))  )  Order By Instrb(PYSM00,'xxbfx'),PYSM00) where Rownum<=100