1 11:27:55 SQL Prepare: ORACLE - select C.BMMC00 DQBQMC,Trim(replace(B.CYXJ00,chr(10),'$')) CYXJ00,A.*,B.*,D.YBMC00,E.FBMC00 RYFBMC,F.YZCS00,F.YZYBJE,D.SFXNH0, (select decode(count(*),0,0,1) bafsbz from zy_basyxx f where f.zyid00=B.zyid00 and f.fscgbz='1' ) BAFSBZ, (select decode(count(*),0,0,1) zdlrbz from bq_brzdxx g where g.zyid00=B.zyid00 and g.zdlb00='3' ) ZDLRBZ, (select YSZJHM from bm_ygbm00 where ygbh00=decode(B.ZZYS00,0,B.SXYS00,B.ZZYS00)) YSZJHM from VW_SF_BRXX00 A, ZY_BRXXB0 B,bm_bmbm00 C,IC_YBBRLB D,BM_BRFBB0 E,ZY_BRZHXX F where A.BRID00 = B.BRID00 and B.DQBQ00 = C.BMBH00 and B.YBLB00 = D.YBLB00 and B.FBBH00 = D.FBBH00 and B.FBBH00 = E.FBBH00 AND A.BRID00 = F.BRID00 and A.MRN000 = '014601' ORDER BY B.ZYID00 desc 2 11:27:55 SQL Execute: ORACLE - select C.BMMC00 DQBQMC,Trim(replace(B.CYXJ00,chr(10),'$')) CYXJ00,A.*,B.*,D.YBMC00,E.FBMC00 RYFBMC,F.YZCS00,F.YZYBJE,D.SFXNH0, (select decode(count(*),0,0,1) bafsbz from zy_basyxx f where f.zyid00=B.zyid00 and f.fscgbz='1' ) BAFSBZ, (select decode(count(*),0,0,1) zdlrbz from bq_brzdxx g where g.zyid00=B.zyid00 and g.zdlb00='3' ) ZDLRBZ, (select YSZJHM from bm_ygbm00 where ygbh00=decode(B.ZZYS00,0,B.SXYS00,B.ZZYS00)) YSZJHM from VW_SF_BRXX00 A, ZY_BRXXB0 B,bm_bmbm00 C,IC_YBBRLB D,BM_BRFBB0 E,ZY_BRZHXX F where A.BRID00 = B.BRID00 and B.DQBQ00 = C.BMBH00 and B.YBLB00 = D.YBLB00 and B.FBBH00 = D.FBBH00 and B.FBBH00 = E.FBBH00 AND A.BRID00 = F.BRID00 and A.MRN000 = '014601' ORDER BY B.ZYID00 desc 3 11:27:55 SQL Blob IO: ORACLE - Return blob data 4 11:27:55 SQL Stmt: ORACLE - Fetch 5 11:27:55 SQL Data Out: ORACLE - Column = 1, Name = DQBQMC, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 外科病区 6 11:27:55 SQL Data Out: ORACLE - Column = 3, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 768201.000000 7 11:27:55 SQL Data Out: ORACLE - Column = 4, Name = MRN000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 014601 8 11:27:55 SQL Data Out: ORACLE - Column = 5, Name = BRBLH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 0 9 11:27:55 SQL Data Out: ORACLE - Column = 6, Name = YBKH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = J99900022 10 11:27:55 SQL Data Out: ORACLE - Column = 7, Name = YBID00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 352225198710112512 11 11:27:55 SQL Data Out: ORACLE - Column = 8, Name = YBLB00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 3 12 11:27:55 SQL Data Out: ORACLE - Column = 9, Name = YBLBMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 宁德医疗保险管理中心 13 11:27:55 SQL Data Out: ORACLE - Column = 10, Name = BRXM00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 测试3 14 11:27:55 SQL Data Out: ORACLE - Column = 11, Name = BRXB00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 男 15 11:27:55 SQL Data Out: ORACLE - Column = 12, Name = BRXX00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 16 11:27:55 SQL Data Out: ORACLE - Column = 13, Name = BRCSRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19871011 17 11:27:55 SQL Data Out: ORACLE - Column = 14, Name = BRHYZK, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 18 11:27:55 SQL Data Out: ORACLE - Column = 15, Name = BRZY00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 19 11:27:55 SQL Data Out: ORACLE - Column = 16, Name = BRMZ00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 汉 20 11:27:55 SQL Data Out: ORACLE - Column = 17, Name = BRGJ00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 中国 21 11:27:55 SQL Data Out: ORACLE - Column = 18, Name = BRZJLX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 身份证 22 11:27:55 SQL Data Out: ORACLE - Column = 19, Name = BRZJBH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 23 11:27:55 SQL Data Out: ORACLE - Column = 20, Name = FBBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 3.000000 24 11:27:55 SQL Data Out: ORACLE - Column = 21, Name = FBMC00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 医保 25 11:27:55 SQL Data Out: ORACLE - Column = 22, Name = BRGFZH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 0 26 11:27:55 SQL Data Out: ORACLE - Column = 23, Name = BRDYFW, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 福建省 27 11:27:55 SQL Data Out: ORACLE - Column = 24, Name = BRDH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 28 11:27:55 SQL Data Out: ORACLE - Column = 25, Name = BRJTDZ, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 29 11:27:55 SQL Data Out: ORACLE - Column = 26, Name = BRYB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 30 11:27:55 SQL Data Out: ORACLE - Column = 27, Name = BRYB01, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 31 11:27:55 SQL Data Out: ORACLE - Column = 28, Name = TYDWID, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 32 11:27:55 SQL Data Out: ORACLE - Column = 29, Name = TYDWMC, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 33 11:27:55 SQL Data Out: ORACLE - Column = 30, Name = BRLXGX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 34 11:27:55 SQL Data Out: ORACLE - Column = 31, Name = BRLXXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 35 11:27:55 SQL Data Out: ORACLE - Column = 32, Name = BRLXDZ, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 36 11:27:55 SQL Data Out: ORACLE - Column = 33, Name = BRLXDH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 37 11:27:55 SQL Data Out: ORACLE - Column = 34, Name = BRZTQK, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 在职人员 38 11:27:55 SQL Data Out: ORACLE - Column = 35, Name = BRJKQK, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 39 11:27:55 SQL Data Out: ORACLE - Column = 36, Name = BRLX00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 初诊 40 11:27:55 SQL Data Out: ORACLE - Column = 37, Name = CZY000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 261.000000 41 11:27:55 SQL Data Out: ORACLE - Column = 38, Name = CZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110407 42 11:27:55 SQL Data Out: ORACLE - Column = 39, Name = CZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:06:46 43 11:27:55 SQL Data Out: ORACLE - Column = 40, Name = SHR000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = NULL 44 11:27:55 SQL Data Out: ORACLE - Column = 41, Name = SHRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 45 11:27:55 SQL Data Out: ORACLE - Column = 42, Name = RYCS00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 46 11:27:55 SQL Data Out: ORACLE - Column = 43, Name = CYQKJE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = NULL 47 11:27:55 SQL Data Out: ORACLE - Column = 44, Name = SFYD00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 48 11:27:55 SQL Data Out: ORACLE - Column = 45, Name = BZ0000, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 49 11:27:55 SQL Data Out: ORACLE - Column = 46, Name = SFYXJB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 50 11:27:55 SQL Data Out: ORACLE - Column = 47, Name = BJJBIE, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 51 11:27:55 SQL Data Out: ORACLE - Column = 48, Name = TSSXMC, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 普通 52 11:27:55 SQL Data Out: ORACLE - Column = 49, Name = YBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 53 11:27:55 SQL Data Out: ORACLE - Column = 50, Name = BRSZSF, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 54 11:27:55 SQL Data Out: ORACLE - Column = 51, Name = BRSZS0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 55 11:27:55 SQL Data Out: ORACLE - Column = 52, Name = BRSZZ0, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 56 11:27:55 SQL Data Out: ORACLE - Column = 53, Name = BRSZC0, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 57 11:27:55 SQL Data Out: ORACLE - Column = 54, Name = SFXNH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 58 11:27:55 SQL Data Out: ORACLE - Column = 55, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 82601.000000 59 11:27:55 SQL Data Out: ORACLE - Column = 56, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 768201.000000 60 11:27:55 SQL Data Out: ORACLE - Column = 57, Name = MRN000, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 014601 61 11:27:55 SQL Data Out: ORACLE - Column = 58, Name = ZYH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = 014601 62 11:27:55 SQL Data Out: ORACLE - Column = 59, Name = YBZYH0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = YD0086395 63 11:27:55 SQL Data Out: ORACLE - Column = 60, Name = XM0000, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 测试3 64 11:27:55 SQL Data Out: ORACLE - Column = 61, Name = XB0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 男 65 11:27:55 SQL Data Out: ORACLE - Column = 62, Name = CSRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 19871011 66 11:27:55 SQL Data Out: ORACLE - Column = 63, Name = FBBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 3.000000 67 11:27:55 SQL Data Out: ORACLE - Column = 64, Name = LBBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 2.000000 68 11:27:55 SQL Data Out: ORACLE - Column = 65, Name = RYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110407 69 11:27:55 SQL Data Out: ORACLE - Column = 66, Name = RYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:06:46 70 11:27:55 SQL Data Out: ORACLE - Column = 67, Name = RYCZY0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 261.000000 71 11:27:55 SQL Data Out: ORACLE - Column = 68, Name = CZYXM0, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 超级用户A 72 11:27:55 SQL Data Out: ORACLE - Column = 69, Name = RYZD00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = S01.701 73 11:27:55 SQL Data Out: ORACLE - Column = 70, Name = RYSQK0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 一般 74 11:27:55 SQL Data Out: ORACLE - Column = 71, Name = RYLB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 普通 75 11:27:55 SQL Data Out: ORACLE - Column = 72, Name = RYBQ00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 33.000000 76 11:27:55 SQL Data Out: ORACLE - Column = 73, Name = RZKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 22.000000 77 11:27:55 SQL Data Out: ORACLE - Column = 74, Name = RYCWH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 407 78 11:27:55 SQL Data Out: ORACLE - Column = 75, Name = DQBQ00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 33.000000 79 11:27:55 SQL Data Out: ORACLE - Column = 76, Name = DQKS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 22.000000 80 11:27:55 SQL Data Out: ORACLE - Column = 77, Name = RCYFH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 治愈 81 11:27:55 SQL Data Out: ORACLE - Column = 78, Name = CYRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110407 82 11:27:55 SQL Data Out: ORACLE - Column = 79, Name = CYSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 11:19:17 83 11:27:55 SQL Data Out: ORACLE - Column = 80, Name = CYCZY0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 261.000000 84 11:27:55 SQL Data Out: ORACLE - Column = 81, Name = CYYGXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 超级用户A 85 11:27:55 SQL Data Out: ORACLE - Column = 82, Name = ZZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 395.000000 86 11:27:55 SQL Data Out: ORACLE - Column = 83, Name = ZZYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 高承业 87 11:27:55 SQL Data Out: ORACLE - Column = 84, Name = ZRYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 395.000000 88 11:27:55 SQL Data Out: ORACLE - Column = 85, Name = ZRYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 高承业 89 11:27:55 SQL Data Out: ORACLE - Column = 86, Name = SXYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 395.000000 90 11:27:55 SQL Data Out: ORACLE - Column = 87, Name = SXYSXM, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 高承业 91 11:27:55 SQL Data Out: ORACLE - Column = 88, Name = HLJBID, Type = fldFLOAT, Precision = 8, Scale = 0, Data = NULL 92 11:27:55 SQL Data Out: ORACLE - Column = 89, Name = BRRYCS, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1.000000 93 11:27:55 SQL Data Out: ORACLE - Column = 90, Name = BRZT00, Type = fldZSTRING, Precision = 2, Scale = 0, Data = 4 94 11:27:55 SQL Data Out: ORACLE - Column = 91, Name = CYDJRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110407 95 11:27:55 SQL Data Out: ORACLE - Column = 92, Name = CYDJSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 00:00:00 96 11:27:55 SQL Data Out: ORACLE - Column = 93, Name = GSDJH0, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 97 11:27:55 SQL Data Out: ORACLE - Column = 95, Name = YBZXLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 98 11:27:55 SQL Data Out: ORACLE - Column = 96, Name = YBBRLB, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 99 11:27:55 SQL Data Out: ORACLE - Column = 97, Name = YBLB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 3 100 11:27:55 SQL Data Out: ORACLE - Column = 98, Name = ZKJCBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 101 11:27:55 SQL Data Out: ORACLE - Column = 99, Name = YBQH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 102 11:27:55 SQL Data Out: ORACLE - Column = 100, Name = YKSH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 103 11:27:55 SQL Data Out: ORACLE - Column = 101, Name = YBKH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = J99900022 104 11:27:55 SQL Data Out: ORACLE - Column = 102, Name = SJCYRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110407 105 11:27:55 SQL Data Out: ORACLE - Column = 103, Name = SJRYRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110407 106 11:27:55 SQL Data Out: ORACLE - Column = 104, Name = SJRYSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:13:03 107 11:27:55 SQL Data Out: ORACLE - Column = 105, Name = SZYS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 0.000000 108 11:27:55 SQL Data Out: ORACLE - Column = 106, Name = YBZYCS, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 2.000000 109 11:27:55 SQL Data Out: ORACLE - Column = 107, Name = SHJG00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 110 11:27:55 SQL Data Out: ORACLE - Column = 108, Name = RYZDMC, Type = fldZSTRING, Precision = 200, Scale = 0, Data = 头部多处外伤，开放性 111 11:27:55 SQL Data Out: ORACLE - Column = 109, Name = SSMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = NULL 112 11:27:55 SQL Data Out: ORACLE - Column = 110, Name = CSLX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 113 11:27:55 SQL Data Out: ORACLE - Column = 111, Name = FYHJJE, Type = fldFLOAT, Precision = 14, Scale = 4, Data = NULL 114 11:27:55 SQL Data Out: ORACLE - Column = 112, Name = YSZID0, Type = fldFLOAT, Precision = 5, Scale = 0, Data = NULL 115 11:27:55 SQL Data Out: ORACLE - Column = 113, Name = YBMC00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 宁德医疗保险管理中心 116 11:27:55 SQL Data Out: ORACLE - Column = 114, Name = RYFBMC, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 医保 117 11:27:55 SQL Data Out: ORACLE - Column = 115, Name = YZCS00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 0.000000 118 11:27:55 SQL Data Out: ORACLE - Column = 116, Name = YZYBJE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 119 11:27:55 SQL Data Out: ORACLE - Column = 117, Name = SFXNH0, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 120 11:27:55 SQL Data Out: ORACLE - Column = 118, Name = BAFSBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 121 11:27:55 SQL Data Out: ORACLE - Column = 119, Name = ZDLRBZ, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1.000000 122 11:27:55 SQL Data Out: ORACLE - Column = 120, Name = YSZJHM, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 高承业 123 11:27:55 SQL Stmt: ORACLE - Fetch 124 11:27:55 SQL Stmt: ORACLE - EOF 125 11:27:55 SQL Stmt: ORACLE - Reset 126 11:27:58 SQL Prepare: ORACLE - select ssbh00,ssmc00,ssrq00,mzbabh mzbh00,a.mzmc00,rownum from bq_ssmzxx a,bm_mzzd00 b where Trim(substr(a.MZBH00,INSTR(';'||a.MZBH00,';',-1),4)) =b.mzbh00(+) and a.ZYID00=82601 and rownum<=8 order by id0000 127 11:27:58 SQL Execute: ORACLE - select ssbh00,ssmc00,ssrq00,mzbabh mzbh00,a.mzmc00,rownum from bq_ssmzxx a,bm_mzzd00 b where Trim(substr(a.MZBH00,INSTR(';'||a.MZBH00,';',-1),4)) =b.mzbh00(+) and a.ZYID00=82601 and rownum<=8 order by id0000 128 11:27:58 SQL Stmt: ORACLE - Fetch 129 11:27:58 SQL Stmt: ORACLE - EOF 130 11:27:58 SQL Stmt: ORACLE - Reset 131 11:27:58 SQL Stmt: ORACLE - Close 132 11:27:58 SQL Prepare: ORACLE - select bmmc00 from bm_bmbm00 where bmbh00=22 133 11:27:58 SQL Execute: ORACLE - select bmmc00 from bm_bmbm00 where bmbh00=22 134 11:27:58 SQL Stmt: ORACLE - Fetch 135 11:27:58 SQL Data Out: ORACLE - Column = 1, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 外科 136 11:27:58 SQL Stmt: ORACLE - Reset 137 11:27:58 SQL Stmt: ORACLE - Close 138 11:27:58 SQL Prepare: ORACLE - select bmmc00 from bm_bmbm00 where bmbh00=33 139 11:27:58 SQL Execute: ORACLE - select bmmc00 from bm_bmbm00 where bmbh00=33 140 11:27:58 SQL Stmt: ORACLE - Fetch 141 11:27:58 SQL Data Out: ORACLE - Column = 1, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 外科病区 142 11:27:58 SQL Stmt: ORACLE - Reset 143 11:27:58 SQL Stmt: ORACLE - Close 144 11:27:58 SQL Prepare: ORACLE - select bmmc00 from bm_bmbm00 where bmbh00=22 145 11:27:58 SQL Execute: ORACLE - select bmmc00 from bm_bmbm00 where bmbh00=22 146 11:27:58 SQL Stmt: ORACLE - Fetch 147 11:27:58 SQL Data Out: ORACLE - Column = 1, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 外科 148 11:27:58 SQL Stmt: ORACLE - Reset 149 11:27:58 SQL Stmt: ORACLE - Close 150 11:27:58 SQL Prepare: ORACLE - select bmmc00 from bm_bmbm00 where bmbh00=33 151 11:27:58 SQL Execute: ORACLE - select bmmc00 from bm_bmbm00 where bmbh00=33 152 11:27:58 SQL Stmt: ORACLE - Fetch 153 11:27:58 SQL Data Out: ORACLE - Column = 1, Name = BMMC00, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 外科病区 154 11:27:58 SQL Stmt: ORACLE - Reset 155 11:27:58 SQL Stmt: ORACLE - Close 156 11:27:58 SQL Prepare: ORACLE - select * from BQ_BRZDXX where ZDLB00>='2' and ZDLB00<='9' and ZYID00=82601 order by zdlb00 157 11:27:58 SQL Execute: ORACLE - select * from BQ_BRZDXX where ZDLB00>='2' and ZDLB00<='9' and ZYID00=82601 order by zdlb00 158 11:27:58 SQL Stmt: ORACLE - Fetch 159 11:27:58 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 36621.000000 160 11:27:58 SQL Data Out: ORACLE - Column = 2, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 768201.000000 161 11:27:58 SQL Data Out: ORACLE - Column = 3, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 82601.000000 162 11:27:58 SQL Data Out: ORACLE - Column = 4, Name = ZDLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 163 11:27:58 SQL Data Out: ORACLE - Column = 5, Name = ZDM000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = S01.701 164 11:27:58 SQL Data Out: ORACLE - Column = 6, Name = ZDMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 头部多处外伤，开放性 165 11:27:58 SQL Data Out: ORACLE - Column = 7, Name = ZDRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110407 166 11:27:58 SQL Data Out: ORACLE - Column = 8, Name = ZDSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:13:03 167 11:27:58 SQL Data Out: ORACLE - Column = 9, Name = SFYZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 168 11:27:58 SQL Data Out: ORACLE - Column = 10, Name = ZLXG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 6 169 11:27:58 SQL Data Out: ORACLE - Column = 11, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 261.000000 170 11:27:58 SQL Data Out: ORACLE - Column = 12, Name = YQBGBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 171 11:27:58 SQL Data Out: ORACLE - Column = 13, Name = ZDFS00, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000 172 11:27:58 SQL Data Out: ORACLE - Column = 14, Name = CRDJID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 173 11:27:58 SQL Data Out: ORACLE - Column = 15, Name = BZ0000, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 174 11:27:58 SQL Stmt: ORACLE - Fetch 175 11:27:58 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 36622.000000 176 11:27:58 SQL Data Out: ORACLE - Column = 2, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 768201.000000 177 11:27:58 SQL Data Out: ORACLE - Column = 3, Name = ZYID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 82601.000000 178 11:27:58 SQL Data Out: ORACLE - Column = 4, Name = ZDLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 179 11:27:58 SQL Data Out: ORACLE - Column = 5, Name = ZDM000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = S01.701 180 11:27:58 SQL Data Out: ORACLE - Column = 6, Name = ZDMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 头部多处外伤，开放性 181 11:27:58 SQL Data Out: ORACLE - Column = 7, Name = ZDRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20110407 182 11:27:58 SQL Data Out: ORACLE - Column = 8, Name = ZDSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:30:13 183 11:27:58 SQL Data Out: ORACLE - Column = 9, Name = SFYZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 184 11:27:58 SQL Data Out: ORACLE - Column = 10, Name = ZLXG00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 185 11:27:58 SQL Data Out: ORACLE - Column = 11, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 261.000000 186 11:27:58 SQL Data Out: ORACLE - Column = 12, Name = YQBGBZ, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 187 11:27:58 SQL Data Out: ORACLE - Column = 13, Name = ZDFS00, Type = fldFLOAT, Precision = 1, Scale = 0, Data = 1.000000 188 11:27:58 SQL Data Out: ORACLE - Column = 14, Name = CRDJID, Type = fldFLOAT, Precision = 10, Scale = 0, Data = NULL 189 11:27:58 SQL Data Out: ORACLE - Column = 15, Name = BZ0000, Type = fldZSTRING, Precision = 100, Scale = 0, Data = NULL 190 11:27:58 SQL Stmt: ORACLE - Fetch 191 11:27:58 SQL Stmt: ORACLE - EOF 192 11:27:58 SQL Stmt: ORACLE - Reset 193 11:27:58 SQL Stmt: ORACLE - Close 194 11:27:58 SQL Prepare: ORACLE - select ssbh00,nvl((select trim(xxms00) from bm_zlzd00 F where f.zlxmid= a.ssbh00),a.ssmc00) SSMC00,ssrq00,mzbabh mzbh00,rownum from bq_ssmzxx a,bm_mzzd00 b where Trim(substr(a.MZBH00,INSTR(';'||a.MZBH00,';',-1),4)) =b.mzbh00(+) and a.ZYID00=82601 and rownum<=8 order by id0000 195 11:27:58 SQL Execute: ORACLE - select ssbh00,nvl((select trim(xxms00) from bm_zlzd00 F where f.zlxmid= a.ssbh00),a.ssmc00) SSMC00,ssrq00,mzbabh mzbh00,rownum from bq_ssmzxx a,bm_mzzd00 b where Trim(substr(a.MZBH00,INSTR(';'||a.MZBH00,';',-1),4)) =b.mzbh00(+) and a.ZYID00=82601 and rownum<=8 order by id0000 196 11:27:58 SQL Stmt: ORACLE - Fetch 197 11:27:58 SQL Stmt: ORACLE - EOF 198 11:27:58 SQL Stmt: ORACLE - Reset