1 09:59:19 Log started for: 住院医生工作站系统 2 09:59:24 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = %% 3 09:59:24 SQL Execute: ORACLE - Select * from (select YPMC00,YPGG00,YPBM00,PYSM00,WBSM00,YPNM00,LSJXX0,SJKCXX,YBLBMC,ZFBL00,BZ0000,NBLBMC,NBZFBL,LBBH00,YPXZ00,YBJSDJ,YPSYSM,COLOUR from VW_BQ_YBYP00 where (PYSM00 Like ?) and( YBZXLB = '1' and YBBRLB = 'C' and YFBMBH = '160' and LBBH00 = '2' and ( (exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00 and BZ0000='内科病区')) or (not exists (select 1 from VW_BQ_BQZYYP where YPNM00=VW_BQ_YBYP00.YPNM00)) ) ) Order By PYSM00) where Rownum<=100