1 11:08:12 SQL Stmt: ORACLE - Reset 2 11:08:12 SQL Stmt: ORACLE - Close 3 11:08:12 SQL Prepare: ORACLE - select SF_SF_GETFYJSXZXX(477254.00,3.00) as TSXX00 from dual 4 11:08:12 SQL Execute: ORACLE - select SF_SF_GETFYJSXZXX(477254.00,3.00) as TSXX00 from dual 5 11:08:12 SQL Blob IO: ORACLE - Return blob data 6 11:08:12 SQL Stmt: ORACLE - Fetch 7 11:08:12 SQL Stmt: ORACLE - Close 8 11:08:12 SQL Prepare: ORACLE - select trim(MC0000) MC0000 from BM_TYZD00 where ZDMC00 = '事前审方-事前审方系统' and BZ0000 = '是否启用审方系统' 9 11:08:12 SQL Execute: ORACLE - select trim(MC0000) MC0000 from BM_TYZD00 where ZDMC00 = '事前审方-事前审方系统' and BZ0000 = '是否启用审方系统' 10 11:08:12 SQL Stmt: ORACLE - Fetch 11 11:08:12 SQL Data Out: ORACLE - Column = 1, Name = MC0000, Type = fldZSTRING, Precision = 200, Scale = 0, Data = 1 12 11:08:12 SQL Stmt: ORACLE - Close 13 11:08:12 SQL Prepare: ORACLE - select * from VW_SQSF_DSCFDL where BRID00 = :1 and SQSFZT = '3' 14 11:08:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 15 11:08:12 SQL Execute: ORACLE - select * from VW_SQSF_DSCFDL where BRID00 = ? and SQSFZT = '3' 16 11:08:12 SQL Blob IO: ORACLE - Return blob data 17 11:08:12 SQL Stmt: ORACLE - Fetch 18 11:08:12 SQL Stmt: ORACLE - EOF 19 11:08:12 SQL Stmt: ORACLE - Reset 20 11:08:12 SQL Stmt: ORACLE - Close 21 11:08:12 SQL Prepare: ORACLE - select * from VW_SQSF_DSCFDL where BRID00 = :1 and SQSFZT in ('1', '4') 22 11:08:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 23 11:08:12 SQL Execute: ORACLE - select * from VW_SQSF_DSCFDL where BRID00 = ? and SQSFZT in ('1', '4') 24 11:08:12 SQL Blob IO: ORACLE - Return blob data 25 11:08:12 SQL Stmt: ORACLE - Fetch 26 11:08:12 SQL Stmt: ORACLE - EOF 27 11:08:12 SQL Stmt: ORACLE - Reset 28 11:08:12 SQL Prepare: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '第三方电子发票平台接口' and BH0000 = 'DSFDZFPPT_KHDLJ' 29 11:08:12 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '第三方电子发票平台接口' and BH0000 = 'DSFDZFPPT_KHDLJ' 30 11:08:12 SQL Stmt: ORACLE - Fetch 31 11:08:12 SQL Data Out: ORACLE - Column = 1, Name = BH0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = DSFDZFPPT_KHDLJ 32 11:08:12 SQL Data Out: ORACLE - Column = 2, Name = MC0000, Type = fldZSTRING, Precision = 200, Scale = 0, Data = 0 33 11:08:12 SQL Stmt: ORACLE - Reset 34 11:08:12 SQL Stmt: ORACLE - Close 35 11:08:12 SQL Prepare: ORACLE - select SF_SF_GETYNFPPJXH(1,126,1) as PJXH00 from dual 36 11:08:12 SQL Execute: ORACLE - select SF_SF_GETYNFPPJXH(1,126,1) as PJXH00 from dual 37 11:08:12 SQL Blob IO: ORACLE - Return blob data 38 11:08:12 SQL Stmt: ORACLE - Fetch 39 11:08:12 SQL Stmt: ORACLE - Reset 40 11:08:12 SQL Stmt: ORACLE - Close 41 11:08:12 SQL Prepare: ORACLE - select SF_SF_GETYNFPPJXH(1,126,22) as PJXH00 from dual 42 11:08:12 SQL Execute: ORACLE - select SF_SF_GETYNFPPJXH(1,126,22) as PJXH00 from dual 43 11:08:12 SQL Blob IO: ORACLE - Return blob data 44 11:08:12 SQL Stmt: ORACLE - Fetch 45 11:08:12 SQL Stmt: ORACLE - Reset 46 11:08:12 SQL Stmt: ORACLE - Close 47 11:08:12 SQL Stmt: ORACLE - Close 48 11:08:12 SQL Prepare: ORACLE - select SRRQ00,LBMC00,D.GHH000,F.GHRQ00 from YF_MZCF00 D,BM_YPLB00 E,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND D.YPDLBH=E.LBBH00 and D.CFZT00 in ('0','5') and D.BCCFH0 in (select CFLSH0 from yf_mzcf00 A,sf_brfy00 B where A.DJH000=B.DJH000 and B.JZDH00+0=0 and b.brid00= :1) and d.srrq00>=to_char(sysdate-:2,'YYYYMMDD') 49 11:08:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 50 11:08:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 51 11:08:12 SQL Execute: ORACLE - select SRRQ00,LBMC00,D.GHH000,F.GHRQ00 from YF_MZCF00 D,BM_YPLB00 E,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND D.YPDLBH=E.LBBH00 and D.CFZT00 in ('0','5') and D.BCCFH0 in (select CFLSH0 from yf_mzcf00 A,sf_brfy00 B where A.DJH000=B.DJH000 and B.JZDH00+0=0 and b.brid00= ?) and d.srrq00>=to_char(sysdate-?,'YYYYMMDD') 52 11:08:12 SQL Stmt: ORACLE - Fetch 53 11:08:12 SQL Stmt: ORACLE - EOF 54 11:08:12 SQL Stmt: ORACLE - Reset 55 11:08:12 SQL Stmt: ORACLE - Close 56 11:08:12 SQL Prepare: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND d.brid00=:1 and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00+0 = 0 and a.brid00= :2) and d.kdrq00>=to_char(sysdate-:3,'YYYYMMDD') 57 11:08:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 58 11:08:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 59 11:08:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 60 11:08:12 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and D.GHH000=F.GHH000 AND d.brid00=? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00+0 = 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 61 11:08:12 SQL Stmt: ORACLE - Fetch 62 11:08:12 SQL Stmt: ORACLE - EOF 63 11:08:12 SQL Stmt: ORACLE - Reset 64 11:08:12 SQL Stmt: ORACLE - Close 65 11:08:12 SQL Prepare: ORACLE - select a.SRRQ00,D.LBMC00,A.GHH000,F.GHRQ00 from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d,SF_BRXXB0 F where 1 = 1 and a.ghh000=f.ghh000 and B.BRID00= :1 and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000=C.DJH000 and B.JZDH00+0<>0 and A.srrq00>=to_char(sysdate-:2,'YYYYMMDD') and A.YPDLBH=D.LBBH00 66 11:08:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 67 11:08:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 68 11:08:12 SQL Execute: ORACLE - select a.SRRQ00,D.LBMC00,A.GHH000,F.GHRQ00 from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d,SF_BRXXB0 F where 1 = 1 and a.ghh000=f.ghh000 and B.BRID00= ? and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000=C.DJH000 and B.JZDH00+0<>0 and A.srrq00>=to_char(sysdate-?,'YYYYMMDD') and A.YPDLBH=D.LBBH00 69 11:08:12 SQL Stmt: ORACLE - Fetch 70 11:08:12 SQL Stmt: ORACLE - EOF 71 11:08:12 SQL Stmt: ORACLE - Reset 72 11:08:12 SQL Stmt: ORACLE - Close 73 11:08:12 SQL Prepare: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and d.ghh000=f.ghh000 and d.brid00= :1 and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00> 0 and a.brid00= :2) and d.kdrq00>=to_char(sysdate-:3,'YYYYMMDD') 74 11:08:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 75 11:08:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 76 11:08:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 77 11:08:12 SQL Execute: ORACLE - select kdrq00,zlxmjc,D.GHH000,F.GHRQ00 from VW_SF_YJYW00 D,SF_BRXXB0 F where 1=1 and d.ghh000=f.ghh000 and d.brid00= ? and D.SFDJH0+0 = 0 and D.CXDJH0 in ( select b.YJDJH0 from YJ_YW0000 b,SF_BRFY00 a where b.SFDJH0=a.djh000 and a.JZDH00> 0 and a.brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') 78 11:08:12 SQL Stmt: ORACLE - Fetch 79 11:08:12 SQL Stmt: ORACLE - EOF 80 11:08:12 SQL Stmt: ORACLE - Reset 81 11:08:12 SQL Stmt: ORACLE - Close 82 11:08:12 SQL Prepare: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 in( '0','5') and b.brid00=:1 and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= :2) and B.srrq00>=to_char(sysdate-:3,'YYYYMMDD') and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 83 11:08:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 84 11:08:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 85 11:08:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 86 11:08:12 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 in( '0','5') and b.brid00=? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 87 11:08:12 SQL Stmt: ORACLE - Fetch 88 11:08:12 SQL Stmt: ORACLE - EOF 89 11:08:12 SQL Stmt: ORACLE - Reset 90 11:08:12 SQL Stmt: ORACLE - Close 91 11:08:12 SQL Prepare: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 = '1' and b.brid00= :1 and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= :2) and B.srrq00>=to_char(sysdate-:3,'YYYYMMDD') and b.bccfh0 is null and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 92 11:08:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 93 11:08:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 94 11:08:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 95 11:08:12 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 from YF_MZCF00 B,BM_YPLB00 C,SF_BRXXB0 F where 1=1 and b.ghh000=f.ghh000 and B.CFZT00 = '1' and b.brid00= ? and not exists (select 1 from yf_mzcf00 where bccfh0=b.cflsh0 and brid00= ?) and B.srrq00>=to_char(sysdate-?,'YYYYMMDD') and b.bccfh0 is null and B.YPDLBH=C.LBBH00 group by C.LBMC00,B.SRRQ00,B.GHH000,F.GHRQ00 96 11:08:12 SQL Stmt: ORACLE - Fetch 97 11:08:12 SQL Stmt: ORACLE - EOF 98 11:08:12 SQL Stmt: ORACLE - Reset 99 11:08:12 SQL Stmt: ORACLE - Close 100 11:08:12 SQL Prepare: ORACLE - select count(1) ss,e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 from YJ_YW0000 D,bm_bmbm00 e,SF_BRXXB0 F WHERE 1=1 and D.ZYHGHH=F.GHH000 and d.MZZYBZ='0' and D.XMZT00 in( '1') and nvl(CXDJH0,0)=0 and D.brid00= :1 and not exists (select 1 from yj_yw0000 where cxdjh0=d.yjdjh0 and brid00= :2) and d.kdrq00>=to_char(sysdate-:3,'YYYYMMDD') and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 101 11:08:12 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 102 11:08:12 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 477254.000000 103 11:08:12 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 2, Scale = 0, Data = 20 104 11:08:12 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 from YJ_YW0000 D,bm_bmbm00 e,SF_BRXXB0 F WHERE 1=1 and D.ZYHGHH=F.GHH000 and d.MZZYBZ='0' and D.XMZT00 in( '1') and nvl(CXDJH0,0)=0 and D.brid00= ? and not exists (select 1 from yj_yw0000 where cxdjh0=d.yjdjh0 and brid00= ?) and d.kdrq00>=to_char(sysdate-?,'YYYYMMDD') and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.zlxmjc,D.KDRQ00,D.ZYHGHH,F.GHRQ00 105 11:08:12 SQL Stmt: ORACLE - Fetch 106 11:08:12 SQL Stmt: ORACLE - EOF 107 11:08:12 SQL Stmt: ORACLE - Reset 108 11:08:13 SQL Prepare: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS' 109 11:08:13 SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00 = '电子虚拟健康卡' and BH0000 = 'DZJKKSYFS' 110 11:08:13 SQL Stmt: ORACLE - Fetch 111 11:08:13 SQL Data Out: ORACLE - Column = 1, Name = BH0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = DZJKKSYFS 112 11:08:13 SQL Data Out: ORACLE - Column = 2, Name = MC0000, Type = fldZSTRING, Precision = 200, Scale = 0, Data = 1 113 11:08:13 SQL Stmt: ORACLE - Reset 114 11:08:13 SQL Stmt: ORACLE - Close 115 11:08:13 SQL Prepare: ORACLE - Select SYSDATE from Dual 116 11:08:13 SQL Execute: ORACLE - Select SYSDATE from Dual 117 11:08:13 SQL Stmt: ORACLE - Fetch 118 11:08:13 SQL Data Out: ORACLE - Column = 1, Name = SYSDATE, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/14/2024 11:8:14:0 119 11:08:13 SQL Stmt: ORACLE - Reset 120 11:08:13 SQL Stmt: ORACLE - Close 121 11:08:13 SQL Prepare: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 122 11:08:13 SQL Execute: ORACLE - Select KLDH00,KLLB00,KHQZBH from IC_KLDM00 where SYBZ00 <> '0' and KLDH00 not in ('ALL','YY-ALL','YB-ALL') and KLDH00 = 'SLE4442' and KLDH00 not in ('CK','JMCK') 123 11:08:13 SQL Stmt: ORACLE - Fetch 124 11:08:13 SQL Data Out: ORACLE - Column = 1, Name = KLDH00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = SLE4442 125 11:08:13 SQL Data Out: ORACLE - Column = 2, Name = KLLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 126 11:08:13 SQL Data Out: ORACLE - Column = 3, Name = KHQZBH, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 127 11:08:13 SQL Stmt: ORACLE - Reset 128 11:08:13 SQL Stmt: ORACLE - Close 129 11:08:13 SQL Prepare: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222212600161172' and ICKNBH = '0222212600161172' 130 11:08:13 SQL Execute: ORACLE - select ICKH00,YGBH00,BRID00,KMH000,ZT0000 from IC_YHXX00 where ICKH00 = '0222212600161172' and ICKNBH = '0222212600161172' 131 11:08:13 SQL Stmt: ORACLE - Fetch 132 11:08:13 SQL Data Out: ORACLE - Column = 1, Name = ICKH00, Type = fldZSTRING, Precision = 220, Scale = 0, Data = 0222212600161172 133 11:08:13 SQL Data Out: ORACLE - Column = 2, Name = YGBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 134 11:08:13 SQL Data Out: ORACLE - Column = 3, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 477254.000000 135 11:08:13 SQL Data Out: ORACLE - Column = 4, Name = KMH000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 00161172 136 11:08:13 SQL Data Out: ORACLE - Column = 5, Name = ZT0000, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 137 11:08:13 SQL Stmt: ORACLE - Reset 138 11:08:13 SQL Stmt: ORACLE - Close 139 11:08:13 SQL Stmt: ORACLE - Reset 140 11:08:13 SQL Stmt: ORACLE - Close 141 11:08:13 SQL Prepare: ORACLE - select * from BM_TYZD00 where ZDMC00='不孕症诊断字典' and YXBZ00='1' 142 11:08:13 SQL Execute: ORACLE - select * from BM_TYZD00 where ZDMC00='不孕症诊断字典' and YXBZ00='1' 143 11:08:13 SQL Stmt: ORACLE - Fetch 144 11:08:13 SQL Stmt: ORACLE - EOF 145 11:08:13 SQL Stmt: ORACLE - Reset 146 11:08:13 SQL Stmt: ORACLE - Close 147 11:08:13 SQL Prepare: ORACLE - select count(1) ss,C.LBMC00 from YF_MZCF00 B,BM_YPLB00 C where 1=1 and B.CFZT00 in( '0','5') and b.brid00=477254 and B.YPDLBH=C.LBBH00 group by C.LBMC00 148 11:08:13 SQL Execute: ORACLE - select count(1) ss,C.LBMC00 from YF_MZCF00 B,BM_YPLB00 C where 1=1 and B.CFZT00 in( '0','5') and b.brid00=477254 and B.YPDLBH=C.LBBH00 group by C.LBMC00 149 11:08:13 SQL Stmt: ORACLE - Fetch 150 11:08:13 SQL Data Out: ORACLE - Column = 1, Name = SS, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2.000000 151 11:08:13 SQL Data Out: ORACLE - Column = 2, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 152 11:08:13 SQL Stmt: ORACLE - Reset 153 11:08:13 SQL Stmt: ORACLE - Close 154 11:08:13 SQL Prepare: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00 from YF_MZCF00 B,BM_YPLB00 C where 1=1 and B.CFZT00 = '1' and b.brid00=477254 and B.YPDLBH=C.LBBH00 and b.bccfh0 is null group by C.LBMC00,B.SRRQ00 155 11:08:13 SQL Execute: ORACLE - select count(1) ss,C.LBMC00,B.SRRQ00 from YF_MZCF00 B,BM_YPLB00 C where 1=1 and B.CFZT00 = '1' and b.brid00=477254 and B.YPDLBH=C.LBBH00 and b.bccfh0 is null group by C.LBMC00,B.SRRQ00 156 11:08:13 SQL Stmt: ORACLE - Fetch 157 11:08:13 SQL Stmt: ORACLE - EOF 158 11:08:13 SQL Stmt: ORACLE - Reset 159 11:08:13 SQL Stmt: ORACLE - Close 160 11:08:13 SQL Prepare: ORACLE - select * from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d where 1 = 1 and B.BRID00=477254 and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000 = C.DJH000 and B.JZDH00+0 <> 0 and A.YPDLBH=D.LBBH00 161 11:08:13 SQL Execute: ORACLE - select * from YF_MZCF00 A,sf_brfy00 B,yf_mzcf00 C,BM_YPLB00 d where 1 = 1 and B.BRID00=477254 and A.CFZT00 IN('0','5') and A.BCCFH0 = C.CFLSH0 and B.DJH000 = C.DJH000 and B.JZDH00+0 <> 0 and A.YPDLBH=D.LBBH00 162 11:08:13 SQL Blob IO: ORACLE - Return blob data 163 11:08:13 SQL Stmt: ORACLE - Fetch 164 11:08:13 SQL Data Out: ORACLE - Column = 1, Name = CFLSH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4013855 165 11:08:13 SQL Data Out: ORACLE - Column = 2, Name = YFBMBH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 122.000000 166 11:08:13 SQL Data Out: ORACLE - Column = 3, Name = GHID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 7265901.000000 167 11:08:13 SQL Data Out: ORACLE - Column = 4, Name = GHH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7265901 168 11:08:13 SQL Data Out: ORACLE - Column = 5, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 477254.000000 169 11:08:13 SQL Data Out: ORACLE - Column = 6, Name = BRXM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 万建平 170 11:08:13 SQL Data Out: ORACLE - Column = 7, Name = XB0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 男 171 11:08:13 SQL Data Out: ORACLE - Column = 8, Name = CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20041019 172 11:08:13 SQL Data Out: ORACLE - Column = 9, Name = DJH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 173 11:08:13 SQL Data Out: ORACLE - Column = 10, Name = YSGZH0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 174 11:08:13 SQL Data Out: ORACLE - Column = 11, Name = YSXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 测试人员9 175 11:08:13 SQL Data Out: ORACLE - Column = 12, Name = SSKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 15.000000 176 11:08:13 SQL Data Out: ORACLE - Column = 13, Name = GHKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 15.000000 177 11:08:13 SQL Data Out: ORACLE - Column = 14, Name = ZYTS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = 1.000000 178 11:08:13 SQL Data Out: ORACLE - Column = 15, Name = YPDLBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 179 11:08:13 SQL Data Out: ORACLE - Column = 16, Name = CFXZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 180 11:08:13 SQL Data Out: ORACLE - Column = 17, Name = BZID00, Type = fldFLOAT, Precision = 6, Scale = 0, Data = 0.000000 181 11:08:13 SQL Data Out: ORACLE - Column = 18, Name = BZMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 182 11:08:13 SQL Data Out: ORACLE - Column = 19, Name = CFZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 5 183 11:08:13 SQL Data Out: ORACLE - Column = 20, Name = FJFDJH, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 20490075.000000 184 11:08:13 SQL Data Out: ORACLE - Column = 21, Name = CZY000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 185 11:08:13 SQL Data Out: ORACLE - Column = 22, Name = PFR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 186 11:08:13 SQL Data Out: ORACLE - Column = 23, Name = FHR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 187 11:08:13 SQL Data Out: ORACLE - Column = 24, Name = FYR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 188 11:08:13 SQL Data Out: ORACLE - Column = 25, Name = SRRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240801 189 11:08:13 SQL Data Out: ORACLE - Column = 26, Name = SRSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:32:40 190 11:08:13 SQL Data Out: ORACLE - Column = 27, Name = JZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 191 11:08:13 SQL Data Out: ORACLE - Column = 28, Name = JZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 192 11:08:13 SQL Data Out: ORACLE - Column = 29, Name = FYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240801 193 11:08:13 SQL Data Out: ORACLE - Column = 30, Name = FYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:33:57 194 11:08:13 SQL Data Out: ORACLE - Column = 31, Name = CFZJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = -8.270000 195 11:08:13 SQL Data Out: ORACLE - Column = 32, Name = BRDZ00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 196 11:08:13 SQL Data Out: ORACLE - Column = 33, Name = BZ0000, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 197 11:08:13 SQL Data Out: ORACLE - Column = 34, Name = BCCFH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4013853 198 11:08:13 SQL Data Out: ORACLE - Column = 35, Name = SFKSLY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 199 11:08:13 SQL Data Out: ORACLE - Column = 36, Name = PSZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 200 11:08:13 SQL Data Out: ORACLE - Column = 37, Name = LYDH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 201 11:08:13 SQL Data Out: ORACLE - Column = 38, Name = LYR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 202 11:08:13 SQL Data Out: ORACLE - Column = 39, Name = CFSRBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 203 11:08:13 SQL Data Out: ORACLE - Column = 40, Name = ZYDJS0, Type = fldFLOAT, Precision = 2, Scale = 0, Data = 0.000000 204 11:08:13 SQL Data Out: ORACLE - Column = 41, Name = THBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 205 11:08:13 SQL Data Out: ORACLE - Column = 42, Name = LYKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 206 11:08:13 SQL Data Out: ORACLE - Column = 43, Name = CYJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 207 11:08:13 SQL Data Out: ORACLE - Column = 44, Name = YXJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 208 11:08:13 SQL Data Out: ORACLE - Column = 45, Name = SFXJJZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 209 11:08:13 SQL Data Out: ORACLE - Column = 46, Name = TSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = NULL 210 11:08:13 SQL Data Out: ORACLE - Column = 47, Name = CFBDCS, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 211 11:08:13 SQL Data Out: ORACLE - Column = 48, Name = CFXLH0, Type = fldZSTRING, Precision = 15, Scale = 0, Data = NULL 212 11:08:13 SQL Data Out: ORACLE - Column = 49, Name = YGLSH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 213 11:08:13 SQL Data Out: ORACLE - Column = 50, Name = CFDGS0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 214 11:08:13 SQL Data Out: ORACLE - Column = 51, Name = THYY00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 215 11:08:13 SQL Data Out: ORACLE - Column = 52, Name = ZYMRCS, Type = fldFLOAT, Precision = 2, Scale = 0, Data = 2.000000 216 11:08:13 SQL Data Out: ORACLE - Column = 53, Name = DMCFBH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 217 11:08:13 SQL Data Out: ORACLE - Column = 54, Name = SHBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 218 11:08:13 SQL Data Out: ORACLE - Column = 55, Name = YYBHID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 219 11:08:13 SQL Data Out: ORACLE - Column = 56, Name = SFHY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 220 11:08:13 SQL Data Out: ORACLE - Column = 57, Name = ZYSFJJ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 221 11:08:13 SQL Data Out: ORACLE - Column = 58, Name = ZYSFNJ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 222 11:08:13 SQL Data Out: ORACLE - Column = 59, Name = ZYNJJL, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 223 11:08:13 SQL Data Out: ORACLE - Column = 60, Name = TSYS00, Type = fldFLOAT, Precision = 1, Scale = 0, Data = -1.000000 224 11:08:13 SQL Data Out: ORACLE - Column = 61, Name = ZJZFID, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 225 11:08:13 SQL Data Out: ORACLE - Column = 62, Name = ZYMRJS, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000 226 11:08:13 SQL Data Out: ORACLE - Column = 63, Name = FHR001, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 227 11:08:13 SQL Data Out: ORACLE - Column = 64, Name = DYCJSL, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 228 11:08:13 SQL Data Out: ORACLE - Column = 65, Name = DYCJQL, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 229 11:08:13 SQL Data Out: ORACLE - Column = 66, Name = DECJSL, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 230 11:08:13 SQL Data Out: ORACLE - Column = 67, Name = DECJQL, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 231 11:08:13 SQL Data Out: ORACLE - Column = 68, Name = JYFS00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 232 11:08:13 SQL Data Out: ORACLE - Column = 69, Name = YPCZFL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 233 11:08:13 SQL Data Out: ORACLE - Column = 70, Name = DJFSMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 234 11:08:13 SQL Data Out: ORACLE - Column = 71, Name = BRZJBH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 235 11:08:13 SQL Data Out: ORACLE - Column = 72, Name = ZRZYLS, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 236 11:08:13 SQL Data Out: ORACLE - Column = 73, Name = SFYXQY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 237 11:08:13 SQL Data Out: ORACLE - Column = 75, Name = ZDM000, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 238 11:08:13 SQL Data Out: ORACLE - Column = 76, Name = ZDMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 239 11:08:13 SQL Data Out: ORACLE - Column = 77, Name = LRJMLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 240 11:08:13 SQL Data Out: ORACLE - Column = 78, Name = SFKSJC, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 241 11:08:13 SQL Data Out: ORACLE - Column = 79, Name = YWCFBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 242 11:08:13 SQL Data Out: ORACLE - Column = 80, Name = PFCZR0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 243 11:08:13 SQL Data Out: ORACLE - Column = 81, Name = PYGZLS, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 244 11:08:13 SQL Data Out: ORACLE - Column = 82, Name = SFPDQH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 245 11:08:13 SQL Data Out: ORACLE - Column = 83, Name = LYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 246 11:08:13 SQL Data Out: ORACLE - Column = 84, Name = LYRQSJ, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 247 11:08:13 SQL Data Out: ORACLE - Column = 85, Name = DYCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = 0.000000 248 11:08:13 SQL Data Out: ORACLE - Column = 86, Name = KFPC00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 249 11:08:13 SQL Data Out: ORACLE - Column = 87, Name = YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 250 11:08:13 SQL Data Out: ORACLE - Column = 88, Name = TCID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 251 11:08:13 SQL Data Out: ORACLE - Column = 89, Name = TCNWBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 252 11:08:13 SQL Data Out: ORACLE - Column = 90, Name = JKSFFS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 253 11:08:13 SQL Data Out: ORACLE - Column = 91, Name = SQSFZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 254 11:08:13 SQL Data Out: ORACLE - Column = 92, Name = WGCFBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 255 11:08:13 SQL Data Out: ORACLE - Column = 93, Name = JKFYCK, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 256 11:08:13 SQL Data Out: ORACLE - Column = 94, Name = JZDH00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 257 11:08:13 SQL Data Out: ORACLE - Column = 95, Name = FYCKBH, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 258 11:08:13 SQL Data Out: ORACLE - Column = 96, Name = YPHJH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 259 11:08:13 SQL Data Out: ORACLE - Column = 97, Name = DBRXM0, Type = fldZSTRING, Precision = 32, Scale = 0, Data = NULL 260 11:08:13 SQL Data Out: ORACLE - Column = 98, Name = DBRZJH, Type = fldZSTRING, Precision = 32, Scale = 0, Data = NULL 261 11:08:13 SQL Data Out: ORACLE - Column = 99, Name = XDFBZ0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 262 11:08:13 SQL Data Out: ORACLE - Column = 100, Name = KDJFRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 263 11:08:13 SQL Data Out: ORACLE - Column = 101, Name = KDJFSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 264 11:08:13 SQL Data Out: ORACLE - Column = 102, Name = ZFCFBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 265 11:08:13 SQL Data Out: ORACLE - Column = 103, Name = WGCFSX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 266 11:08:13 SQL Data Out: ORACLE - Column = 104, Name = SFJG00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 267 11:08:13 SQL Data Out: ORACLE - Column = 105, Name = YYSFR0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 268 11:08:13 SQL Data Out: ORACLE - Column = 106, Name = SFCAQM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 269 11:08:13 SQL Data Out: ORACLE - Column = 107, Name = ZSZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 270 11:08:13 SQL Data Out: ORACLE - Column = 108, Name = DJH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 20490074.000000 271 11:08:13 SQL Data Out: ORACLE - Column = 109, Name = YBDJH0, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 0 272 11:08:13 SQL Data Out: ORACLE - Column = 110, Name = MZID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 7265901.000000 273 11:08:13 SQL Data Out: ORACLE - Column = 111, Name = MZH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7265901 274 11:08:13 SQL Data Out: ORACLE - Column = 112, Name = JFLBID, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 275 11:08:13 SQL Data Out: ORACLE - Column = 113, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 477254.000000 276 11:08:13 SQL Data Out: ORACLE - Column = 114, Name = XM0000, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 万建平 277 11:08:13 SQL Data Out: ORACLE - Column = 115, Name = BRFB00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 3.000000 278 11:08:13 SQL Data Out: ORACLE - Column = 116, Name = HJJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 8.270000 279 11:08:13 SQL Data Out: ORACLE - Column = 117, Name = ZFJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 8.270000 280 11:08:13 SQL Data Out: ORACLE - Column = 118, Name = GFJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 281 11:08:13 SQL Data Out: ORACLE - Column = 119, Name = JZJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 282 11:08:13 SQL Data Out: ORACLE - Column = 120, Name = BRYE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 19717.730000 283 11:08:13 SQL Data Out: ORACLE - Column = 121, Name = CZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240801 284 11:08:13 SQL Data Out: ORACLE - Column = 122, Name = CZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:32:31 285 11:08:13 SQL Data Out: ORACLE - Column = 123, Name = CZY000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 286 11:08:13 SQL Data Out: ORACLE - Column = 124, Name = CZYXM0, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 测试人员9 287 11:08:13 SQL Data Out: ORACLE - Column = 125, Name = CZYKS0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 122.000000 288 11:08:13 SQL Data Out: ORACLE - Column = 126, Name = JZDH00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 942209.000000 289 11:08:13 SQL Data Out: ORACLE - Column = 127, Name = CXDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 290 11:08:13 SQL Data Out: ORACLE - Column = 128, Name = CXPJR0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 291 11:08:13 SQL Data Out: ORACLE - Column = 129, Name = CXYY00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 292 11:08:13 SQL Data Out: ORACLE - Column = 130, Name = SFYKBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 293 11:08:13 SQL Data Out: ORACLE - Column = 131, Name = QZFJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 294 11:08:13 SQL Data Out: ORACLE - Column = 132, Name = YJJZID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 295 11:08:13 SQL Data Out: ORACLE - Column = 133, Name = XMLY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 296 11:08:13 SQL Data Out: ORACLE - Column = 134, Name = ZZZHZF, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 297 11:08:13 SQL Data Out: ORACLE - Column = 135, Name = SYDJH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 298 11:08:13 SQL Data Out: ORACLE - Column = 136, Name = BJDJH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 299 11:08:13 SQL Data Out: ORACLE - Column = 137, Name = YYDJH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 300 11:08:13 SQL Data Out: ORACLE - Column = 138, Name = ZRZYLS, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 301 11:08:13 SQL Data Out: ORACLE - Column = 139, Name = YBLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = W4 302 11:08:13 SQL Data Out: ORACLE - Column = 140, Name = KFQDBM, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 303 11:08:13 SQL Data Out: ORACLE - Column = 141, Name = CFLSH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 4013853 304 11:08:13 SQL Data Out: ORACLE - Column = 142, Name = YFBMBH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 122.000000 305 11:08:13 SQL Data Out: ORACLE - Column = 143, Name = GHID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 7265901.000000 306 11:08:13 SQL Data Out: ORACLE - Column = 144, Name = GHH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7265901 307 11:08:13 SQL Data Out: ORACLE - Column = 145, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 477254.000000 308 11:08:13 SQL Data Out: ORACLE - Column = 146, Name = BRXM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 万建平 309 11:08:13 SQL Data Out: ORACLE - Column = 147, Name = XB0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 男 310 11:08:13 SQL Data Out: ORACLE - Column = 148, Name = CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20041019 311 11:08:13 SQL Data Out: ORACLE - Column = 149, Name = DJH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 20490074.000000 312 11:08:13 SQL Data Out: ORACLE - Column = 150, Name = YSGZH0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 313 11:08:13 SQL Data Out: ORACLE - Column = 151, Name = YSXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 测试人员9 314 11:08:13 SQL Data Out: ORACLE - Column = 152, Name = SSKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 15.000000 315 11:08:13 SQL Data Out: ORACLE - Column = 153, Name = GHKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 15.000000 316 11:08:13 SQL Data Out: ORACLE - Column = 154, Name = ZYTS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = 1.000000 317 11:08:13 SQL Data Out: ORACLE - Column = 155, Name = YPDLBH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 318 11:08:13 SQL Data Out: ORACLE - Column = 156, Name = CFXZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 319 11:08:13 SQL Data Out: ORACLE - Column = 157, Name = BZID00, Type = fldFLOAT, Precision = 6, Scale = 0, Data = 0.000000 320 11:08:13 SQL Data Out: ORACLE - Column = 158, Name = BZMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 321 11:08:13 SQL Data Out: ORACLE - Column = 159, Name = CFZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 322 11:08:13 SQL Data Out: ORACLE - Column = 160, Name = FJFDJH, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 20490075.000000 323 11:08:13 SQL Data Out: ORACLE - Column = 161, Name = CZY000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 324 11:08:13 SQL Data Out: ORACLE - Column = 162, Name = PFR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 325 11:08:13 SQL Data Out: ORACLE - Column = 163, Name = FHR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 326 11:08:13 SQL Data Out: ORACLE - Column = 164, Name = FYR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 327 11:08:13 SQL Data Out: ORACLE - Column = 165, Name = SRRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240801 328 11:08:13 SQL Data Out: ORACLE - Column = 166, Name = SRSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:33:16 329 11:08:13 SQL Data Out: ORACLE - Column = 167, Name = JZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240801 330 11:08:13 SQL Data Out: ORACLE - Column = 168, Name = JZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:32:31 331 11:08:13 SQL Data Out: ORACLE - Column = 169, Name = FYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240801 332 11:08:13 SQL Data Out: ORACLE - Column = 170, Name = FYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 17:32:31 333 11:08:13 SQL Data Out: ORACLE - Column = 171, Name = CFZJE0, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 8.270000 334 11:08:13 SQL Data Out: ORACLE - Column = 172, Name = BRDZ00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 335 11:08:13 SQL Data Out: ORACLE - Column = 173, Name = BZ0000, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 336 11:08:13 SQL Data Out: ORACLE - Column = 174, Name = BCCFH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 337 11:08:13 SQL Data Out: ORACLE - Column = 175, Name = SFKSLY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 338 11:08:13 SQL Data Out: ORACLE - Column = 176, Name = PSZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 339 11:08:13 SQL Data Out: ORACLE - Column = 177, Name = LYDH00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 340 11:08:13 SQL Data Out: ORACLE - Column = 178, Name = LYR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 341 11:08:13 SQL Data Out: ORACLE - Column = 179, Name = CFSRBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 342 11:08:13 SQL Data Out: ORACLE - Column = 180, Name = ZYDJS0, Type = fldFLOAT, Precision = 2, Scale = 0, Data = 0.000000 343 11:08:13 SQL Data Out: ORACLE - Column = 181, Name = THBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 344 11:08:13 SQL Data Out: ORACLE - Column = 182, Name = LYKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 345 11:08:13 SQL Data Out: ORACLE - Column = 183, Name = CYJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 346 11:08:13 SQL Data Out: ORACLE - Column = 184, Name = YXJE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 347 11:08:13 SQL Data Out: ORACLE - Column = 185, Name = SFXJJZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 348 11:08:13 SQL Data Out: ORACLE - Column = 186, Name = TSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = NULL 349 11:08:13 SQL Data Out: ORACLE - Column = 187, Name = CFBDCS, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 350 11:08:13 SQL Data Out: ORACLE - Column = 188, Name = CFXLH0, Type = fldZSTRING, Precision = 15, Scale = 0, Data = NULL 351 11:08:13 SQL Data Out: ORACLE - Column = 189, Name = YGLSH0, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 352 11:08:13 SQL Data Out: ORACLE - Column = 190, Name = CFDGS0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 353 11:08:13 SQL Data Out: ORACLE - Column = 191, Name = THYY00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 354 11:08:13 SQL Data Out: ORACLE - Column = 192, Name = ZYMRCS, Type = fldFLOAT, Precision = 2, Scale = 0, Data = 2.000000 355 11:08:13 SQL Data Out: ORACLE - Column = 193, Name = DMCFBH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 356 11:08:13 SQL Data Out: ORACLE - Column = 194, Name = SHBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 357 11:08:13 SQL Data Out: ORACLE - Column = 195, Name = YYBHID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 358 11:08:13 SQL Data Out: ORACLE - Column = 196, Name = SFHY00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 359 11:08:13 SQL Data Out: ORACLE - Column = 197, Name = ZYSFJJ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 360 11:08:13 SQL Data Out: ORACLE - Column = 198, Name = ZYSFNJ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 361 11:08:13 SQL Data Out: ORACLE - Column = 199, Name = ZYNJJL, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 362 11:08:13 SQL Data Out: ORACLE - Column = 200, Name = TSYS00, Type = fldFLOAT, Precision = 1, Scale = 0, Data = -1.000000 363 11:08:13 SQL Data Out: ORACLE - Column = 201, Name = ZJZFID, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 364 11:08:13 SQL Data Out: ORACLE - Column = 202, Name = ZYMRJS, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000 365 11:08:13 SQL Data Out: ORACLE - Column = 203, Name = FHR001, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 366 11:08:13 SQL Data Out: ORACLE - Column = 204, Name = DYCJSL, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 367 11:08:13 SQL Data Out: ORACLE - Column = 205, Name = DYCJQL, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 368 11:08:13 SQL Data Out: ORACLE - Column = 206, Name = DECJSL, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 369 11:08:13 SQL Data Out: ORACLE - Column = 207, Name = DECJQL, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 370 11:08:13 SQL Data Out: ORACLE - Column = 208, Name = JYFS00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 371 11:08:13 SQL Data Out: ORACLE - Column = 209, Name = YPCZFL, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 372 11:08:13 SQL Data Out: ORACLE - Column = 210, Name = DJFSMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 373 11:08:13 SQL Data Out: ORACLE - Column = 211, Name = BRZJBH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 374 11:08:13 SQL Data Out: ORACLE - Column = 212, Name = ZRZYLS, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 375 11:08:13 SQL Data Out: ORACLE - Column = 213, Name = SFYXQY, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 376 11:08:13 SQL Data Out: ORACLE - Column = 215, Name = ZDM000, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 377 11:08:13 SQL Data Out: ORACLE - Column = 216, Name = ZDMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 378 11:08:13 SQL Data Out: ORACLE - Column = 217, Name = LRJMLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 379 11:08:13 SQL Data Out: ORACLE - Column = 218, Name = SFKSJC, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 380 11:08:13 SQL Data Out: ORACLE - Column = 219, Name = YWCFBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 381 11:08:13 SQL Data Out: ORACLE - Column = 220, Name = PFCZR0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 382 11:08:13 SQL Data Out: ORACLE - Column = 221, Name = PYGZLS, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 383 11:08:13 SQL Data Out: ORACLE - Column = 222, Name = SFPDQH, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 384 11:08:13 SQL Data Out: ORACLE - Column = 223, Name = LYBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 385 11:08:13 SQL Data Out: ORACLE - Column = 224, Name = LYRQSJ, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2024080117:32:31 386 11:08:13 SQL Data Out: ORACLE - Column = 225, Name = DYCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = 0.000000 387 11:08:13 SQL Data Out: ORACLE - Column = 226, Name = KFPC00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 735008.000000 388 11:08:13 SQL Data Out: ORACLE - Column = 227, Name = YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = NULL 389 11:08:13 SQL Data Out: ORACLE - Column = 228, Name = TCID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 390 11:08:13 SQL Data Out: ORACLE - Column = 229, Name = TCNWBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 391 11:08:13 SQL Data Out: ORACLE - Column = 230, Name = JKSFFS, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 392 11:08:13 SQL Data Out: ORACLE - Column = 231, Name = SQSFZT, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 393 11:08:13 SQL Data Out: ORACLE - Column = 232, Name = WGCFBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 394 11:08:13 SQL Data Out: ORACLE - Column = 233, Name = JKFYCK, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 395 11:08:13 SQL Data Out: ORACLE - Column = 234, Name = JZDH00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 396 11:08:13 SQL Data Out: ORACLE - Column = 235, Name = FYCKBH, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 397 11:08:13 SQL Data Out: ORACLE - Column = 236, Name = YPHJH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 398 11:08:13 SQL Data Out: ORACLE - Column = 237, Name = DBRXM0, Type = fldZSTRING, Precision = 32, Scale = 0, Data = NULL 399 11:08:13 SQL Data Out: ORACLE - Column = 238, Name = DBRZJH, Type = fldZSTRING, Precision = 32, Scale = 0, Data = NULL 400 11:08:13 SQL Data Out: ORACLE - Column = 239, Name = XDFBZ0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 401 11:08:13 SQL Data Out: ORACLE - Column = 240, Name = KDJFRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 402 11:08:13 SQL Data Out: ORACLE - Column = 241, Name = KDJFSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 403 11:08:13 SQL Data Out: ORACLE - Column = 242, Name = ZFCFBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 404 11:08:13 SQL Data Out: ORACLE - Column = 243, Name = WGCFSX, Type = fldZSTRING, Precision = 2, Scale = 0, Data = NULL 405 11:08:13 SQL Data Out: ORACLE - Column = 244, Name = SFJG00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 406 11:08:13 SQL Data Out: ORACLE - Column = 245, Name = YYSFR0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 407 11:08:13 SQL Data Out: ORACLE - Column = 246, Name = SFCAQM, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 408 11:08:13 SQL Data Out: ORACLE - Column = 247, Name = ZSZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 409 11:08:13 SQL Data Out: ORACLE - Column = 248, Name = LBBH00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 410 11:08:13 SQL Data Out: ORACLE - Column = 249, Name = YKBMBH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 411 11:08:13 SQL Data Out: ORACLE - Column = 250, Name = LBMC00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药 412 11:08:13 SQL Data Out: ORACLE - Column = 251, Name = SFDM00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 9999999997.000000 413 11:08:13 SQL Data Out: ORACLE - Column = 252, Name = SFXMMC, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 西药费 414 11:08:13 SQL Data Out: ORACLE - Column = 253, Name = MRJCL0, Type = fldFLOAT, Precision = 5, Scale = 4, Data = 0.000000 415 11:08:13 SQL Data Out: ORACLE - Column = 254, Name = UPBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 416 11:08:13 SQL Data Out: ORACLE - Column = 255, Name = YKUPBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 417 11:08:13 SQL Data Out: ORACLE - Column = 256, Name = XGRQSJ, Type = fldZSTRING, Precision = 16, Scale = 0, Data = NULL 418 11:08:13 SQL Data Out: ORACLE - Column = 257, Name = XGR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 419 11:08:13 SQL Data Out: ORACLE - Column = 258, Name = CJRQSJ, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 2018060923:25:23 420 11:08:13 SQL Data Out: ORACLE - Column = 259, Name = SFYX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 421 11:08:13 SQL Data Out: ORACLE - Column = 260, Name = CJR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 422 11:08:13 SQL Stmt: ORACLE - Reset 423 11:08:13 SQL Stmt: ORACLE - Close 424 11:08:13 SQL Prepare: ORACLE - select A.*,g.LBMC00 zlxmjc_1 from VW_SF_YJYW00 A,BM_ZLZD00 H,BM_ZLXMLB G where 1=1 and EXISTS (SELECT 1 FROM YJ_YW0000 C,SF_BRFY00 B WHERE A.GHID00=C.ZYGHID AND A.CXDJH0 = C.YJDJH0 AND C.SFDJH0 = B.DJH000 AND B.JZDH00>0 ) AND A.ZLXMID=H.ZLXMID and G.LBBH00=H.lbbh00 and A.SFDJH0+0 = 0 and a.BRID00=477254 425 11:08:13 SQL Execute: ORACLE - select A.*,g.LBMC00 zlxmjc_1 from VW_SF_YJYW00 A,BM_ZLZD00 H,BM_ZLXMLB G where 1=1 and EXISTS (SELECT 1 FROM YJ_YW0000 C,SF_BRFY00 B WHERE A.GHID00=C.ZYGHID AND A.CXDJH0 = C.YJDJH0 AND C.SFDJH0 = B.DJH000 AND B.JZDH00>0 ) AND A.ZLXMID=H.ZLXMID and G.LBBH00=H.lbbh00 and A.SFDJH0+0 = 0 and a.BRID00=477254 426 11:08:13 SQL Blob IO: ORACLE - Return blob data 427 11:08:13 SQL Stmt: ORACLE - Fetch 428 11:08:13 SQL Data Out: ORACLE - Column = 1, Name = YJDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 20516374.000000 429 11:08:13 SQL Data Out: ORACLE - Column = 2, Name = YJFZH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 430 11:08:13 SQL Data Out: ORACLE - Column = 3, Name = ZLXMJC, Type = fldZSTRING, Precision = 106, Scale = 0, Data = 电子胃镜 431 11:08:13 SQL Data Out: ORACLE - Column = 4, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 477254.000000 432 11:08:13 SQL Data Out: ORACLE - Column = 5, Name = GHID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 7265796.000000 433 11:08:13 SQL Data Out: ORACLE - Column = 6, Name = GHH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 7265796 434 11:08:13 SQL Data Out: ORACLE - Column = 7, Name = BRXM00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 万建平 435 11:08:13 SQL Data Out: ORACLE - Column = 8, Name = XB0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 男 436 11:08:13 SQL Data Out: ORACLE - Column = 9, Name = YJKSBH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 796.000000 437 11:08:13 SQL Data Out: ORACLE - Column = 10, Name = KDYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 375.000000 438 11:08:13 SQL Data Out: ORACLE - Column = 11, Name = KDYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 陈功康 439 11:08:13 SQL Data Out: ORACLE - Column = 12, Name = KDKSBH, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 796.000000 440 11:08:13 SQL Data Out: ORACLE - Column = 13, Name = KDKSMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 病理科 441 11:08:13 SQL Data Out: ORACLE - Column = 14, Name = YJKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 796.000000 442 11:08:13 SQL Data Out: ORACLE - Column = 15, Name = YJKSMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 病理科 443 11:08:13 SQL Data Out: ORACLE - Column = 16, Name = ZXR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 444 11:08:13 SQL Data Out: ORACLE - Column = 17, Name = ZXRXM0, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 测试人员9 445 11:08:13 SQL Data Out: ORACLE - Column = 18, Name = YSSZKS, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 41.000000 446 11:08:13 SQL Data Out: ORACLE - Column = 19, Name = KDRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20240722 447 11:08:13 SQL Data Out: ORACLE - Column = 20, Name = KDSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 16:34:57 448 11:08:13 SQL Data Out: ORACLE - Column = 21, Name = LRXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 测试人员9 449 11:08:13 SQL Data Out: ORACLE - Column = 22, Name = XMZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 450 11:08:13 SQL Data Out: ORACLE - Column = 23, Name = SFDJH0, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 451 11:08:13 SQL Data Out: ORACLE - Column = 24, Name = ZJE000, Type = fldFLOAT, Precision = 12, Scale = 2, Data = -218.000000 452 11:08:13 SQL Data Out: ORACLE - Column = 25, Name = CXDJH0, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 20516373.000000 453 11:08:13 SQL Data Out: ORACLE - Column = 26, Name = TSBZBH, Type = fldZSTRING, Precision = 12, Scale = 0, Data = NULL 454 11:08:13 SQL Data Out: ORACLE - Column = 27, Name = ZLDCCF, Type = fldZSTRING, Precision = 33, Scale = 0, Data = NULL 455 11:08:13 SQL Data Out: ORACLE - Column = 28, Name = BWMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 456 11:08:13 SQL Data Out: ORACLE - Column = 29, Name = BZ0000, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 457 11:08:13 SQL Data Out: ORACLE - Column = 30, Name = ZLXMID, Type = fldFLOAT, Precision = 8, Scale = 0, Data = 42998.000000 458 11:08:13 SQL Data Out: ORACLE - Column = 32, Name = SL0000, Type = fldFLOAT, Precision = 9, Scale = 2, Data = -1.000000 459 11:08:13 SQL Data Out: ORACLE - Column = 33, Name = DW0000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 次 460 11:08:13 SQL Data Out: ORACLE - Column = 34, Name = YYID00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 461 11:08:13 SQL Data Out: ORACLE - Column = 35, Name = JCLBID, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 7.000000 462 11:08:13 SQL Data Out: ORACLE - Column = 36, Name = ZLXMJC_1, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 检查 463 11:08:13 SQL Stmt: ORACLE - Reset 464 11:08:13 SQL Stmt: ORACLE - Close 465 11:08:13 SQL Prepare: ORACLE - select count(1) ss,e.bmmc00,d.kdysxm,d.zlxmjc ZLXMJC,G.zlxmjc ZLXMJC_1,D.KDRQ00 from YJ_YW0000 D,bm_bmbm00 e,XT_KSZXXM f,BM_ZLZD00 G,BM_ZLZD00 H where 1=1 and d.MZZYBZ='0' and D.yjksbh=F.zxksbh and D.XMZT00 in( '1','2') and (0=0 or d.KDRQ00>=to_char(sysdate-0,'YYYYMMDD')) and D.brid00=477254 and d.SL0000 - d.CXSL00 > 0 and G.lbbz00=0 and H.lbbz00=1 and G.zlxmid=H.lbbh00 and d.zlxmid=h.zlxmid and f.ZXKSBH=e.bmbh00 and d.zlxmid=f.ZLXMID group by e.bmmc00,d.kdysxm,d.zlxmjc,G.zlxmjc,D.KDRQ00 466 11:08:13 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.kdysxm,d.zlxmjc ZLXMJC,G.zlxmjc ZLXMJC_1,D.KDRQ00 from YJ_YW0000 D,bm_bmbm00 e,XT_KSZXXM f,BM_ZLZD00 G,BM_ZLZD00 H where 1=1 and d.MZZYBZ='0' and D.yjksbh=F.zxksbh and D.XMZT00 in( '1','2') and (0=0 or d.KDRQ00>=to_char(sysdate-0,'YYYYMMDD')) and D.brid00=477254 and d.SL0000 - d.CXSL00 > 0 and G.lbbz00=0 and H.lbbz00=1 and G.zlxmid=H.lbbh00 and d.zlxmid=h.zlxmid and f.ZXKSBH=e.bmbh00 and d.zlxmid=f.ZLXMID group by e.bmmc00,d.kdysxm,d.zlxmjc,G.zlxmjc,D.KDRQ00 467 11:08:13 SQL Stmt: ORACLE - Fetch 468 11:08:13 SQL Stmt: ORACLE - EOF 469 11:08:13 SQL Stmt: ORACLE - Reset 470 11:08:13 SQL Stmt: ORACLE - Close 471 11:08:13 SQL Prepare: ORACLE - select count(1) ss,e.bmmc00,d.kdysxm,d.zlxmjc ZLXMJC,G.zlxmjc ZLXMJC_1,D.KDRQ00 from YJ_YW0000 D,bm_bmbm00 e,BM_ZLZD00 G,BM_ZLZD00 H where 1=1 and d.MZZYBZ='0' and D.XMZT00 in( '1','2') and (0=0 or d.KDRQ00>=to_char(sysdate-0,'YYYYMMDD')) and D.brid00=477254 and d.SL0000 - d.CXSL00 > 0 and G.lbbz00=0 and H.lbbz00=1 and G.zlxmid=H.lbbh00 and d.zlxmid=h.zlxmid and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.kdysxm,d.zlxmjc,G.zlxmjc,D.KDRQ00 472 11:08:13 SQL Execute: ORACLE - select count(1) ss,e.bmmc00,d.kdysxm,d.zlxmjc ZLXMJC,G.zlxmjc ZLXMJC_1,D.KDRQ00 from YJ_YW0000 D,bm_bmbm00 e,BM_ZLZD00 G,BM_ZLZD00 H where 1=1 and d.MZZYBZ='0' and D.XMZT00 in( '1','2') and (0=0 or d.KDRQ00>=to_char(sysdate-0,'YYYYMMDD')) and D.brid00=477254 and d.SL0000 - d.CXSL00 > 0 and G.lbbz00=0 and H.lbbz00=1 and G.zlxmid=H.lbbh00 and d.zlxmid=h.zlxmid and d.KDKSBH=e.bmbh00 group by e.bmmc00,d.kdysxm,d.zlxmjc,G.zlxmjc,D.KDRQ00 473 11:08:13 SQL Stmt: ORACLE - Fetch 474 11:08:13 SQL Stmt: ORACLE - EOF 475 11:08:13 SQL Stmt: ORACLE - Reset