1       15:44:23  Log started for: SQL Navigator for Oracle
2       15:45:02  Log started for: 住院收费管理系统
3       15:45:19  SQL Prepare: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

4       15:45:19  SQL Execute: ORACLE - select 1 from IC_KLDM00 where KLDH00 not in ('CK','JMCK','ALL','YY-ALL','YB-ALL')

5       15:45:19  SQL Prepare: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

6       15:45:19  SQL Execute: ORACLE - select KLDH00 from IC_KLDM00 where KLDH00 in ('CK','JMCK') and rownum=1

7       15:45:19  SQL Prepare: ORACLE -  select  *  from  vw_bm_brfbb0 

8       15:45:19  SQL Execute: ORACLE -  select  *  from  vw_bm_brfbb0 

9       15:45:19  SQL Prepare: ORACLE - select *  from  BM_TYZD00 where   ZDMC00='医保入院类别对应' order by decode(nvl(xsxh00,0),0,BH0000,XSXH00)

10      15:45:19  SQL Execute: ORACLE - select *  from  BM_TYZD00 where   ZDMC00='医保入院类别对应' order by decode(nvl(xsxh00,0),0,BH0000,XSXH00)

11      15:45:19  SQL Prepare: ORACLE -  select distinct b.BMMC00 From bm_bmbm00 b, zy_brxxb0 a where b.bmbh00=a.rybq00  

12      15:45:19  SQL Execute: ORACLE -  select distinct b.BMMC00 From bm_bmbm00 b, zy_brxxb0 a where b.bmbh00=a.rybq00  

13      15:45:21  SQL Prepare: ORACLE - select A.* from ic_ybbrlb A,bm_brfbb0 B  where A.fbbh00 = B.fbbh00 and B.FBMC00 = :1 order by  A.PXH000,A.YBLB00  desc 

14      15:45:21  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 自费
15      15:45:21  SQL Execute: ORACLE - select A.* from ic_ybbrlb A,bm_brfbb0 B  where A.fbbh00 = B.fbbh00 and B.FBMC00 = ? order by  A.PXH000,A.YBLB00  desc 

16      15:45:45  SQL Prepare: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

17      15:45:45  SQL Execute: ORACLE - select substrb(value0,1,1) from xt_xtcs00 where name00='XT_SRFSLXSCT'

18      15:45:45  SQL Prepare: ORACLE - Select * from (select YBMC00,PYSM00,WBSM00,FBBH00,YBLB00 from VW_SF_YBBRLB where (FBBH00 Like :1) and(  FBMC00='自费' )  Order By FBBH00) where Rownum<=10

19      15:45:45  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
20      15:45:45  SQL Execute: ORACLE - Select * from (select YBMC00,PYSM00,WBSM00,FBBH00,YBLB00 from VW_SF_YBBRLB where (FBBH00 Like ?) and(  FBMC00='自费' )  Order By FBBH00) where Rownum<=10

21      15:45:51  SQL Prepare: ORACLE - Select * from (select YBMC00,PYSM00,WBSM00,FBBH00,YBLB00 from VW_SF_YBBRLB where (PYSM00 Like :1) and(  FBMC00='自费' )  Order By PYSM00) where Rownum<=10

22      15:45:51  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
23      15:45:51  SQL Execute: ORACLE - Select * from (select YBMC00,PYSM00,WBSM00,FBBH00,YBLB00 from VW_SF_YBBRLB where (PYSM00 Like ?) and(  FBMC00='自费' )  Order By PYSM00) where Rownum<=10

24      15:46:04  SQL Prepare: ORACLE - Select * from (select YBMC00,PYSM00,WBSM00,FBBH00,YBLB00 from VW_SF_YBBRLB where (PYSM00 Like :1) and(  FBMC00='自费' )  Order By PYSM00) where Rownum<=10

25      15:46:04  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = %
26      15:46:04  SQL Execute: ORACLE - Select * from (select YBMC00,PYSM00,WBSM00,FBBH00,YBLB00 from VW_SF_YBBRLB where (PYSM00 Like ?) and(  FBMC00='自费' )  Order By PYSM00) where Rownum<=10