1 09:37:48 SQL Prepare: ORACLE - insert into BQ_BRZDXX (ID0000, BRID00, ZYID00, ZDLB00, ZDM000, ZDMC00, ZDRQ00, ZDSJ00, SFYZ00, ZLXG00, LRR000,FZBM00) values (SQ_BQ_BRZDXX_ID0000.NextVal, :1, :2, :3, :4, :5, TO_CHAR(:6,'YYYYMMDD'), TO_CHAR(sysdate,'HH24:MI:SS'), :7, :8, :9,:10) 2 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 2042586.000000 3 09:37:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 4 09:37:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 5 09:37:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = M95.001 6 09:37:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 4, Scale = 0, Data = 鞍鼻 7 09:37:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 8/19/2011 9:37:48:0 8 09:37:48 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 9 09:37:48 SQL Data In: ORACLE - Param = 8, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 10 09:37:48 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 1057.000000 11 09:37:48 SQL Data In: ORACLE - Param = 10, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 12 09:37:48 SQL Execute: ORACLE - insert into BQ_BRZDXX (ID0000, BRID00, ZYID00, ZDLB00, ZDM000, ZDMC00, ZDRQ00, ZDSJ00, SFYZ00, ZLXG00, LRR000,FZBM00) values (SQ_BQ_BRZDXX_ID0000.NextVal, ?, ?, ?, ?, ?, TO_CHAR(?,'YYYYMMDD'), TO_CHAR(sysdate,'HH24:MI:SS'), ?, ?, ?,?) 13 09:37:48 SQL Data In: ORACLE - Rows affected = 1 14 09:37:48 SQL Prepare: ORACLE - update BQ_BRZDXX set ZDLB00 = :1, ZDM000 = :2, ZDMC00 = :3, ZDRQ00 = TO_CHAR(:4,'YYYYMMDD'), ZLXG00 = :5, SFYZ00 = :6, FZBM00 = :7 where ZYID00 = :8 AND ID0000 = :9 15 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 16 09:37:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = M45.002 17 09:37:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 强直性脊柱炎 18 09:37:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 8/17/2011 0:0:0:0 19 09:37:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 20 09:37:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 21 09:37:48 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 22 09:37:48 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 23 09:37:48 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71743.000000 24 09:37:48 SQL Execute: ORACLE - update BQ_BRZDXX set ZDLB00 = ?, ZDM000 = ?, ZDMC00 = ?, ZDRQ00 = TO_CHAR(?,'YYYYMMDD'), ZLXG00 = ?, SFYZ00 = ?, FZBM00 = ? where ZYID00 = ? AND ID0000 = ? 25 09:37:48 SQL Data In: ORACLE - Rows affected = 1 26 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 27 09:37:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = M47.803 28 09:37:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 6, Scale = 0, Data = 颈椎病 29 09:37:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 8/17/2011 0:0:0:0 30 09:37:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 31 09:37:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 32 09:37:48 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 33 09:37:48 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 34 09:37:48 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71744.000000 35 09:37:48 SQL Stmt: ORACLE - Reset 36 09:37:48 SQL Execute: ORACLE - update BQ_BRZDXX set ZDLB00 = ?, ZDM000 = ?, ZDMC00 = ?, ZDRQ00 = TO_CHAR(?,'YYYYMMDD'), ZLXG00 = ?, SFYZ00 = ?, FZBM00 = ? where ZYID00 = ? AND ID0000 = ? 37 09:37:48 SQL Data In: ORACLE - Rows affected = 1 38 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 39 09:37:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = E87.201 40 09:37:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 28, Scale = 0, Data = 呼吸性酸中毒合并代谢性碱中毒 41 09:37:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 8/17/2011 0:0:0:0 42 09:37:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 43 09:37:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 44 09:37:48 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 45 09:37:48 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 46 09:37:48 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71745.000000 47 09:37:48 SQL Stmt: ORACLE - Reset 48 09:37:48 SQL Execute: ORACLE - update BQ_BRZDXX set ZDLB00 = ?, ZDM000 = ?, ZDMC00 = ?, ZDRQ00 = TO_CHAR(?,'YYYYMMDD'), ZLXG00 = ?, SFYZ00 = ?, FZBM00 = ? where ZYID00 = ? AND ID0000 = ? 49 09:37:48 SQL Data In: ORACLE - Rows affected = 1 50 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 51 09:37:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = I47.105 52 09:37:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 20, Scale = 0, Data = 心动过速，阵发性房性 53 09:37:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 8/17/2011 0:0:0:0 54 09:37:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 55 09:37:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 56 09:37:48 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 57 09:37:48 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 58 09:37:48 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71746.000000 59 09:37:48 SQL Stmt: ORACLE - Reset 60 09:37:48 SQL Execute: ORACLE - update BQ_BRZDXX set ZDLB00 = ?, ZDM000 = ?, ZDMC00 = ?, ZDRQ00 = TO_CHAR(?,'YYYYMMDD'), ZLXG00 = ?, SFYZ00 = ?, FZBM00 = ? where ZYID00 = ? AND ID0000 = ? 61 09:37:48 SQL Data In: ORACLE - Rows affected = 1 62 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 63 09:37:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = E77.801 64 09:37:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 低白蛋白血症 65 09:37:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 8/17/2011 0:0:0:0 66 09:37:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 67 09:37:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 68 09:37:48 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 69 09:37:48 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 70 09:37:48 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 71747.000000 71 09:37:48 SQL Stmt: ORACLE - Reset 72 09:37:48 SQL Execute: ORACLE - update BQ_BRZDXX set ZDLB00 = ?, ZDM000 = ?, ZDMC00 = ?, ZDRQ00 = TO_CHAR(?,'YYYYMMDD'), ZLXG00 = ?, SFYZ00 = ?, FZBM00 = ? where ZYID00 = ? AND ID0000 = ? 73 09:37:48 SQL Data In: ORACLE - Rows affected = 1 74 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 75 09:37:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = J98.406 76 09:37:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 肺部感染 77 09:37:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 8/4/2011 0:0:0:0 78 09:37:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 79 09:37:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 80 09:37:48 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 81 09:37:48 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 82 09:37:48 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68473.000000 83 09:37:48 SQL Stmt: ORACLE - Reset 84 09:37:48 SQL Execute: ORACLE - update BQ_BRZDXX set ZDLB00 = ?, ZDM000 = ?, ZDMC00 = ?, ZDRQ00 = TO_CHAR(?,'YYYYMMDD'), ZLXG00 = ?, SFYZ00 = ?, FZBM00 = ? where ZYID00 = ? AND ID0000 = ? 85 09:37:48 SQL Data In: ORACLE - Rows affected = 1 86 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 87 09:37:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = R04.201 88 09:37:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 咯血待查 89 09:37:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 8/4/2011 0:0:0:0 90 09:37:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 91 09:37:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 92 09:37:48 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 93 09:37:48 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 94 09:37:48 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68474.000000 95 09:37:48 SQL Stmt: ORACLE - Reset 96 09:37:48 SQL Execute: ORACLE - update BQ_BRZDXX set ZDLB00 = ?, ZDM000 = ?, ZDMC00 = ?, ZDRQ00 = TO_CHAR(?,'YYYYMMDD'), ZLXG00 = ?, SFYZ00 = ?, FZBM00 = ? where ZYID00 = ? AND ID0000 = ? 97 09:37:48 SQL Data In: ORACLE - Rows affected = 1 98 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 99 09:37:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = J98.406 100 09:37:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 8, Scale = 0, Data = 肺部感染 101 09:37:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 8/4/2011 0:0:0:0 102 09:37:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 103 09:37:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 104 09:37:48 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 105 09:37:48 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 106 09:37:48 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68475.000000 107 09:37:48 SQL Stmt: ORACLE - Reset 108 09:37:48 SQL Execute: ORACLE - update BQ_BRZDXX set ZDLB00 = ?, ZDM000 = ?, ZDMC00 = ?, ZDRQ00 = TO_CHAR(?,'YYYYMMDD'), ZLXG00 = ?, SFYZ00 = ?, FZBM00 = ? where ZYID00 = ? AND ID0000 = ? 109 09:37:48 SQL Data In: ORACLE - Rows affected = 1 110 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 111 09:37:48 SQL Data In: ORACLE - Param = 2, Name = , Type = fldZSTRING, Precision = 7, Scale = 0, Data = B90.901 112 09:37:48 SQL Data In: ORACLE - Param = 3, Name = , Type = fldZSTRING, Precision = 12, Scale = 0, Data = 陈旧性肺结核 113 09:37:48 SQL Data In: ORACLE - Param = 4, Name = , Type = fldTIMESTAMP, Precision = 0, Scale = 0, Data = 8/4/2011 0:0:0:0 114 09:37:48 SQL Data In: ORACLE - Param = 5, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 115 09:37:48 SQL Data In: ORACLE - Param = 6, Name = , Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 116 09:37:48 SQL Data In: ORACLE - Param = 7, Name = , Type = fldZSTRING, Precision = 0, Scale = 0, Data = 117 09:37:48 SQL Data In: ORACLE - Param = 8, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 118 09:37:48 SQL Data In: ORACLE - Param = 9, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 68476.000000 119 09:37:48 SQL Stmt: ORACLE - Reset 120 09:37:48 SQL Execute: ORACLE - update BQ_BRZDXX set ZDLB00 = ?, ZDM000 = ?, ZDMC00 = ?, ZDRQ00 = TO_CHAR(?,'YYYYMMDD'), ZLXG00 = ?, SFYZ00 = ?, FZBM00 = ? where ZYID00 = ? AND ID0000 = ? 121 09:37:48 SQL Data In: ORACLE - Rows affected = 1 122 09:37:48 SQL Prepare: ORACLE - Commit 123 09:37:48 SQL Execute: ORACLE - Commit 124 09:37:48 SQL Data In: ORACLE - Rows affected = 0 125 09:37:48 SQL Stmt: ORACLE - Close 126 09:37:48 SQL Prepare: ORACLE - select a.ZDMC00 from BQ_BRZDXX a,XT_ICD900 b where a.zyid00=340327 and a.ZDLB00='3' and a.ZDM000=b.ICD900 and b.SFCRB0='1' and not exists (select 1 from CR_CRBDJ0 where ZYID00=a.ZYID00 and (JBMC00=a.ZDMC00 OR DJID00=a.CRDJID)) 127 09:37:48 SQL Execute: ORACLE - select a.ZDMC00 from BQ_BRZDXX a,XT_ICD900 b where a.zyid00=340327 and a.ZDLB00='3' and a.ZDM000=b.ICD900 and b.SFCRB0='1' and not exists (select 1 from CR_CRBDJ0 where ZYID00=a.ZYID00 and (JBMC00=a.ZDMC00 OR DJID00=a.CRDJID)) 128 09:37:48 SQL Misc: ORACLE - Set rowset size 129 09:37:48 SQL Stmt: ORACLE - Fetch 130 09:37:48 SQL Stmt: ORACLE - EOF 131 09:37:48 SQL Stmt: ORACLE - Reset 132 09:37:48 SQL Stmt: ORACLE - Close 133 09:37:48 SQL Prepare: ORACLE - select SHBZ00 from BA_BRZYXX where LSH000=:1 134 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 135 09:37:48 SQL Execute: ORACLE - select SHBZ00 from BA_BRZYXX where LSH000=? 136 09:37:48 SQL Misc: ORACLE - Set rowset size 137 09:37:48 SQL Stmt: ORACLE - Fetch 138 09:37:48 SQL Stmt: ORACLE - EOF 139 09:37:48 SQL Data Out: ORACLE - Column = 1, Name = SHBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 140 09:37:48 SQL Stmt: ORACLE - Reset 141 09:37:48 SQL Stmt: ORACLE - Close 142 09:37:48 SQL Prepare: ORACLE - select SHBZ00 from BA_BRZYXX where LSH000=:1 143 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 144 09:37:48 SQL Execute: ORACLE - select SHBZ00 from BA_BRZYXX where LSH000=? 145 09:37:48 SQL Misc: ORACLE - Set rowset size 146 09:37:48 SQL Stmt: ORACLE - Fetch 147 09:37:48 SQL Stmt: ORACLE - EOF 148 09:37:48 SQL Data Out: ORACLE - Column = 1, Name = SHBZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 149 09:37:48 SQL Stmt: ORACLE - Reset 150 09:37:48 SQL Stmt: ORACLE - Close 151 09:37:48 SQL Stmt: ORACLE - Close 152 09:37:48 SQL Prepare: ORACLE - SELECT A.ID0000, A.ZYID00 LSH000,0 ZDXH00, A.ZDLB00,B.VALUE0 AS ZDLBMC, C.ICD900 JBBM00,C.FZM000 XHBM00,A.ZDMC00 JBMC00,A.FZBM00, F.JBMC00 FZMC00, to_date(A.ZDRQ00,'YYYYMMDD') ZDRQ00,A.ZLXG00 ZLXGID,D.MC0000 ZLXG00, A.SFYZ00 SFYZID, E.MC0000 SFYZ00, A.BRID00, A.LRR000, C.M16800 FROM BQ_BRZDXX A ,XT_ZD0000 B, XT_ICD900 C, XT_ZLXG00 D, XT_SFYZ00 E, XT_ICD900 F WHERE A.zyid00=:1 AND A.zdm000=C.icd900(+) AND A.ZDLB00=B.DM0000 AND B.ZDBM00='ZDLB00' AND A.ZLXG00=D.DM0000(+) and A.SFYZ00=E.DM0000(+) and F.icd900(+)=A.FZBM00 and A.ZDFS00='1' 153 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 154 09:37:48 SQL Execute: ORACLE - SELECT A.ID0000, A.ZYID00 LSH000,0 ZDXH00, A.ZDLB00,B.VALUE0 AS ZDLBMC, C.ICD900 JBBM00,C.FZM000 XHBM00,A.ZDMC00 JBMC00,A.FZBM00, F.JBMC00 FZMC00, to_date(A.ZDRQ00,'YYYYMMDD') ZDRQ00,A.ZLXG00 ZLXGID,D.MC0000 ZLXG00, A.SFYZ00 SFYZID, E.MC0000 SFYZ00, A.BRID00, A.LRR000, C.M16800 FROM BQ_BRZDXX A ,XT_ZD0000 B, XT_ICD900 C, XT_ZLXG00 D, XT_SFYZ00 E, XT_ICD900 F WHERE A.zyid00=? AND A.zdm000=C.icd900(+) AND A.ZDLB00=B.DM0000 AND B.ZDBM00='ZDLB00' AND A.ZLXG00=D.DM0000(+) and A.SFYZ00=E.DM0000(+) and F.icd900(+)=A.FZBM00 and A.ZDFS00='1' 155 09:37:48 SQL Misc: ORACLE - Set rowset size 156 09:37:48 SQL Stmt: ORACLE - Fetch 157 09:37:48 SQL Stmt: ORACLE - EOF 158 09:37:48 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 72403.000000 159 09:37:48 SQL Data Out: ORACLE - Column = 2, Name = LSH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 340327.000000 160 09:37:48 SQL Data Out: ORACLE - Column = 3, Name = ZDXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 161 09:37:48 SQL Data Out: ORACLE - Column = 4, Name = ZDLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 162 09:37:48 SQL Data Out: ORACLE - Column = 5, Name = ZDLBMC, Type = fldZSTRING, Precision = 70, Scale = 0, Data = 出院其他诊断 163 09:37:48 SQL Data Out: ORACLE - Column = 6, Name = JBBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = M95.001 164 09:37:48 SQL Data Out: ORACLE - Column = 7, Name = XHBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 165 09:37:48 SQL Data Out: ORACLE - Column = 8, Name = JBMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 鞍鼻 166 09:37:48 SQL Data Out: ORACLE - Column = 9, Name = FZBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 167 09:37:48 SQL Data Out: ORACLE - Column = 10, Name = FZMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 168 09:37:48 SQL Data Out: ORACLE - Column = 11, Name = ZDRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/19/2011 0:0:0:0 169 09:37:48 SQL Data Out: ORACLE - Column = 12, Name = ZLXGID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 170 09:37:48 SQL Data Out: ORACLE - Column = 13, Name = ZLXG00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 171 09:37:48 SQL Data Out: ORACLE - Column = 14, Name = SFYZID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 172 09:37:48 SQL Data Out: ORACLE - Column = 15, Name = SFYZ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 否 173 09:37:48 SQL Data Out: ORACLE - Column = 16, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2042586.000000 174 09:37:48 SQL Data Out: ORACLE - Column = 17, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1057.000000 175 09:37:48 SQL Data Out: ORACLE - Column = 18, Name = M16800, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 176 09:37:48 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 71743.000000 177 09:37:48 SQL Data Out: ORACLE - Column = 2, Name = LSH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 340327.000000 178 09:37:48 SQL Data Out: ORACLE - Column = 3, Name = ZDXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 179 09:37:48 SQL Data Out: ORACLE - Column = 4, Name = ZDLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 180 09:37:48 SQL Data Out: ORACLE - Column = 5, Name = ZDLBMC, Type = fldZSTRING, Precision = 70, Scale = 0, Data = 出院其他诊断 181 09:37:48 SQL Data Out: ORACLE - Column = 6, Name = JBBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = M45.002 182 09:37:48 SQL Data Out: ORACLE - Column = 7, Name = XHBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 183 09:37:48 SQL Data Out: ORACLE - Column = 8, Name = JBMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 强直性脊柱炎 184 09:37:48 SQL Data Out: ORACLE - Column = 9, Name = FZBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 185 09:37:48 SQL Data Out: ORACLE - Column = 10, Name = FZMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 186 09:37:48 SQL Data Out: ORACLE - Column = 11, Name = ZDRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/17/2011 0:0:0:0 187 09:37:48 SQL Data Out: ORACLE - Column = 12, Name = ZLXGID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 188 09:37:48 SQL Data Out: ORACLE - Column = 13, Name = ZLXG00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 好转 189 09:37:48 SQL Data Out: ORACLE - Column = 14, Name = SFYZID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 190 09:37:48 SQL Data Out: ORACLE - Column = 15, Name = SFYZ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 否 191 09:37:48 SQL Data Out: ORACLE - Column = 16, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2042586.000000 192 09:37:48 SQL Data Out: ORACLE - Column = 17, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1282.000000 193 09:37:48 SQL Data Out: ORACLE - Column = 18, Name = M16800, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 194 09:37:48 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 71744.000000 195 09:37:48 SQL Data Out: ORACLE - Column = 2, Name = LSH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 340327.000000 196 09:37:48 SQL Data Out: ORACLE - Column = 3, Name = ZDXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 197 09:37:48 SQL Data Out: ORACLE - Column = 4, Name = ZDLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 198 09:37:48 SQL Data Out: ORACLE - Column = 5, Name = ZDLBMC, Type = fldZSTRING, Precision = 70, Scale = 0, Data = 出院其他诊断 199 09:37:48 SQL Data Out: ORACLE - Column = 6, Name = JBBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = M47.803 200 09:37:48 SQL Data Out: ORACLE - Column = 7, Name = XHBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 201 09:37:48 SQL Data Out: ORACLE - Column = 8, Name = JBMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 颈椎病 202 09:37:48 SQL Data Out: ORACLE - Column = 9, Name = FZBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 203 09:37:48 SQL Data Out: ORACLE - Column = 10, Name = FZMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 204 09:37:48 SQL Data Out: ORACLE - Column = 11, Name = ZDRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/17/2011 0:0:0:0 205 09:37:48 SQL Data Out: ORACLE - Column = 12, Name = ZLXGID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 206 09:37:48 SQL Data Out: ORACLE - Column = 13, Name = ZLXG00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 好转 207 09:37:48 SQL Data Out: ORACLE - Column = 14, Name = SFYZID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 208 09:37:48 SQL Data Out: ORACLE - Column = 15, Name = SFYZ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 否 209 09:37:48 SQL Data Out: ORACLE - Column = 16, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2042586.000000 210 09:37:48 SQL Data Out: ORACLE - Column = 17, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1282.000000 211 09:37:48 SQL Data Out: ORACLE - Column = 18, Name = M16800, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 212 09:37:48 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 71745.000000 213 09:37:48 SQL Data Out: ORACLE - Column = 2, Name = LSH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 340327.000000 214 09:37:48 SQL Data Out: ORACLE - Column = 3, Name = ZDXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 215 09:37:48 SQL Data Out: ORACLE - Column = 4, Name = ZDLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 216 09:37:48 SQL Data Out: ORACLE - Column = 5, Name = ZDLBMC, Type = fldZSTRING, Precision = 70, Scale = 0, Data = 出院其他诊断 217 09:37:48 SQL Data Out: ORACLE - Column = 6, Name = JBBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = E87.201 218 09:37:48 SQL Data Out: ORACLE - Column = 7, Name = XHBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 219 09:37:48 SQL Data Out: ORACLE - Column = 8, Name = JBMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 呼吸性酸中毒合并代谢性碱中毒 220 09:37:48 SQL Data Out: ORACLE - Column = 9, Name = FZBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 221 09:37:48 SQL Data Out: ORACLE - Column = 10, Name = FZMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 222 09:37:48 SQL Data Out: ORACLE - Column = 11, Name = ZDRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/17/2011 0:0:0:0 223 09:37:48 SQL Data Out: ORACLE - Column = 12, Name = ZLXGID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 224 09:37:48 SQL Data Out: ORACLE - Column = 13, Name = ZLXG00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 好转 225 09:37:48 SQL Data Out: ORACLE - Column = 14, Name = SFYZID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 226 09:37:48 SQL Data Out: ORACLE - Column = 15, Name = SFYZ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 否 227 09:37:48 SQL Data Out: ORACLE - Column = 16, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2042586.000000 228 09:37:48 SQL Data Out: ORACLE - Column = 17, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1282.000000 229 09:37:48 SQL Data Out: ORACLE - Column = 18, Name = M16800, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 230 09:37:48 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 71746.000000 231 09:37:48 SQL Data Out: ORACLE - Column = 2, Name = LSH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 340327.000000 232 09:37:48 SQL Data Out: ORACLE - Column = 3, Name = ZDXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 233 09:37:48 SQL Data Out: ORACLE - Column = 4, Name = ZDLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 234 09:37:48 SQL Data Out: ORACLE - Column = 5, Name = ZDLBMC, Type = fldZSTRING, Precision = 70, Scale = 0, Data = 出院其他诊断 235 09:37:48 SQL Data Out: ORACLE - Column = 6, Name = JBBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = I47.105 236 09:37:48 SQL Data Out: ORACLE - Column = 7, Name = XHBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 237 09:37:48 SQL Data Out: ORACLE - Column = 8, Name = JBMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 心动过速，阵发性房性 238 09:37:48 SQL Data Out: ORACLE - Column = 9, Name = FZBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 239 09:37:48 SQL Data Out: ORACLE - Column = 10, Name = FZMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 240 09:37:48 SQL Data Out: ORACLE - Column = 11, Name = ZDRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/17/2011 0:0:0:0 241 09:37:48 SQL Data Out: ORACLE - Column = 12, Name = ZLXGID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 242 09:37:48 SQL Data Out: ORACLE - Column = 13, Name = ZLXG00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 好转 243 09:37:48 SQL Data Out: ORACLE - Column = 14, Name = SFYZID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 244 09:37:48 SQL Data Out: ORACLE - Column = 15, Name = SFYZ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 否 245 09:37:48 SQL Data Out: ORACLE - Column = 16, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2042586.000000 246 09:37:48 SQL Data Out: ORACLE - Column = 17, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1282.000000 247 09:37:48 SQL Data Out: ORACLE - Column = 18, Name = M16800, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 248 09:37:48 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 71747.000000 249 09:37:48 SQL Data Out: ORACLE - Column = 2, Name = LSH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 340327.000000 250 09:37:48 SQL Data Out: ORACLE - Column = 3, Name = ZDXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 251 09:37:48 SQL Data Out: ORACLE - Column = 4, Name = ZDLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 252 09:37:48 SQL Data Out: ORACLE - Column = 5, Name = ZDLBMC, Type = fldZSTRING, Precision = 70, Scale = 0, Data = 出院其他诊断 253 09:37:48 SQL Data Out: ORACLE - Column = 6, Name = JBBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = E77.801 254 09:37:48 SQL Data Out: ORACLE - Column = 7, Name = XHBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 255 09:37:48 SQL Data Out: ORACLE - Column = 8, Name = JBMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 低白蛋白血症 256 09:37:48 SQL Data Out: ORACLE - Column = 9, Name = FZBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 257 09:37:48 SQL Data Out: ORACLE - Column = 10, Name = FZMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 258 09:37:48 SQL Data Out: ORACLE - Column = 11, Name = ZDRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/17/2011 0:0:0:0 259 09:37:48 SQL Data Out: ORACLE - Column = 12, Name = ZLXGID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 260 09:37:48 SQL Data Out: ORACLE - Column = 13, Name = ZLXG00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 治愈 261 09:37:48 SQL Data Out: ORACLE - Column = 14, Name = SFYZID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 262 09:37:48 SQL Data Out: ORACLE - Column = 15, Name = SFYZ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 否 263 09:37:48 SQL Data Out: ORACLE - Column = 16, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2042586.000000 264 09:37:48 SQL Data Out: ORACLE - Column = 17, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1282.000000 265 09:37:48 SQL Data Out: ORACLE - Column = 18, Name = M16800, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 266 09:37:48 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 68473.000000 267 09:37:48 SQL Data Out: ORACLE - Column = 2, Name = LSH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 340327.000000 268 09:37:48 SQL Data Out: ORACLE - Column = 3, Name = ZDXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 269 09:37:48 SQL Data Out: ORACLE - Column = 4, Name = ZDLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 270 09:37:48 SQL Data Out: ORACLE - Column = 5, Name = ZDLBMC, Type = fldZSTRING, Precision = 70, Scale = 0, Data = 门诊诊断 271 09:37:48 SQL Data Out: ORACLE - Column = 6, Name = JBBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = J98.406 272 09:37:48 SQL Data Out: ORACLE - Column = 7, Name = XHBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 273 09:37:48 SQL Data Out: ORACLE - Column = 8, Name = JBMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 肺部感染 274 09:37:48 SQL Data Out: ORACLE - Column = 9, Name = FZBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 275 09:37:48 SQL Data Out: ORACLE - Column = 10, Name = FZMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 276 09:37:48 SQL Data Out: ORACLE - Column = 11, Name = ZDRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/4/2011 0:0:0:0 277 09:37:48 SQL Data Out: ORACLE - Column = 12, Name = ZLXGID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 278 09:37:48 SQL Data Out: ORACLE - Column = 13, Name = ZLXG00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 279 09:37:48 SQL Data Out: ORACLE - Column = 14, Name = SFYZID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 280 09:37:48 SQL Data Out: ORACLE - Column = 15, Name = SFYZ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 否 281 09:37:48 SQL Data Out: ORACLE - Column = 16, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2042586.000000 282 09:37:48 SQL Data Out: ORACLE - Column = 17, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1282.000000 283 09:37:48 SQL Data Out: ORACLE - Column = 18, Name = M16800, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 284 09:37:48 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 68474.000000 285 09:37:48 SQL Data Out: ORACLE - Column = 2, Name = LSH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 340327.000000 286 09:37:48 SQL Data Out: ORACLE - Column = 3, Name = ZDXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 287 09:37:48 SQL Data Out: ORACLE - Column = 4, Name = ZDLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 288 09:37:48 SQL Data Out: ORACLE - Column = 5, Name = ZDLBMC, Type = fldZSTRING, Precision = 70, Scale = 0, Data = 入院诊断 289 09:37:48 SQL Data Out: ORACLE - Column = 6, Name = JBBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = R04.201 290 09:37:48 SQL Data Out: ORACLE - Column = 7, Name = XHBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 291 09:37:48 SQL Data Out: ORACLE - Column = 8, Name = JBMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 咯血待查 292 09:37:48 SQL Data Out: ORACLE - Column = 9, Name = FZBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 293 09:37:48 SQL Data Out: ORACLE - Column = 10, Name = FZMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 294 09:37:48 SQL Data Out: ORACLE - Column = 11, Name = ZDRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/4/2011 0:0:0:0 295 09:37:48 SQL Data Out: ORACLE - Column = 12, Name = ZLXGID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = NULL 296 09:37:48 SQL Data Out: ORACLE - Column = 13, Name = ZLXG00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = NULL 297 09:37:48 SQL Data Out: ORACLE - Column = 14, Name = SFYZID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 298 09:37:48 SQL Data Out: ORACLE - Column = 15, Name = SFYZ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 否 299 09:37:48 SQL Data Out: ORACLE - Column = 16, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2042586.000000 300 09:37:48 SQL Data Out: ORACLE - Column = 17, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1282.000000 301 09:37:48 SQL Data Out: ORACLE - Column = 18, Name = M16800, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 302 09:37:48 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 68475.000000 303 09:37:48 SQL Data Out: ORACLE - Column = 2, Name = LSH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 340327.000000 304 09:37:48 SQL Data Out: ORACLE - Column = 3, Name = ZDXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 305 09:37:48 SQL Data Out: ORACLE - Column = 4, Name = ZDLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 3 306 09:37:48 SQL Data Out: ORACLE - Column = 5, Name = ZDLBMC, Type = fldZSTRING, Precision = 70, Scale = 0, Data = 出院主要诊断 307 09:37:48 SQL Data Out: ORACLE - Column = 6, Name = JBBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = J98.406 308 09:37:48 SQL Data Out: ORACLE - Column = 7, Name = XHBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 309 09:37:48 SQL Data Out: ORACLE - Column = 8, Name = JBMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 肺部感染 310 09:37:48 SQL Data Out: ORACLE - Column = 9, Name = FZBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 311 09:37:48 SQL Data Out: ORACLE - Column = 10, Name = FZMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 312 09:37:48 SQL Data Out: ORACLE - Column = 11, Name = ZDRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/4/2011 0:0:0:0 313 09:37:48 SQL Data Out: ORACLE - Column = 12, Name = ZLXGID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 314 09:37:48 SQL Data Out: ORACLE - Column = 13, Name = ZLXG00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 治愈 315 09:37:48 SQL Data Out: ORACLE - Column = 14, Name = SFYZID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 316 09:37:48 SQL Data Out: ORACLE - Column = 15, Name = SFYZ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 否 317 09:37:48 SQL Data Out: ORACLE - Column = 16, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2042586.000000 318 09:37:48 SQL Data Out: ORACLE - Column = 17, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1282.000000 319 09:37:48 SQL Data Out: ORACLE - Column = 18, Name = M16800, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 320 09:37:48 SQL Data Out: ORACLE - Column = 1, Name = ID0000, Type = fldFLOAT, Precision = 12, Scale = 0, Data = 68476.000000 321 09:37:48 SQL Data Out: ORACLE - Column = 2, Name = LSH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 340327.000000 322 09:37:48 SQL Data Out: ORACLE - Column = 3, Name = ZDXH00, Type = fldFLOAT, Precision = 0, Scale = 0, Data = 0.000000 323 09:37:48 SQL Data Out: ORACLE - Column = 4, Name = ZDLB00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 4 324 09:37:48 SQL Data Out: ORACLE - Column = 5, Name = ZDLBMC, Type = fldZSTRING, Precision = 70, Scale = 0, Data = 出院其他诊断 325 09:37:48 SQL Data Out: ORACLE - Column = 6, Name = JBBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = B90.901 326 09:37:48 SQL Data Out: ORACLE - Column = 7, Name = XHBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 327 09:37:48 SQL Data Out: ORACLE - Column = 8, Name = JBMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 陈旧性肺结核 328 09:37:48 SQL Data Out: ORACLE - Column = 9, Name = FZBM00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = NULL 329 09:37:48 SQL Data Out: ORACLE - Column = 10, Name = FZMC00, Type = fldZSTRING, Precision = 60, Scale = 0, Data = NULL 330 09:37:48 SQL Data Out: ORACLE - Column = 11, Name = ZDRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/4/2011 0:0:0:0 331 09:37:48 SQL Data Out: ORACLE - Column = 12, Name = ZLXGID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 332 09:37:48 SQL Data Out: ORACLE - Column = 13, Name = ZLXG00, Type = fldZSTRING, Precision = 40, Scale = 0, Data = 好转 333 09:37:48 SQL Data Out: ORACLE - Column = 14, Name = SFYZID, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 0 334 09:37:48 SQL Data Out: ORACLE - Column = 15, Name = SFYZ00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 否 335 09:37:48 SQL Data Out: ORACLE - Column = 16, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 2042586.000000 336 09:37:48 SQL Data Out: ORACLE - Column = 17, Name = LRR000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1282.000000 337 09:37:48 SQL Data Out: ORACLE - Column = 18, Name = M16800, Type = fldZSTRING, Precision = 4, Scale = 0, Data = NULL 338 09:37:48 SQL Stmt: ORACLE - Reset 339 09:37:48 SQL Stmt: ORACLE - Reset 340 09:37:48 SQL Stmt: ORACLE - Close 341 09:37:48 SQL Prepare: ORACLE - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,TO_DATE(RYRQ00,'YYYYMMDD') RYRQ00,TO_DATE(CYRQ00,'YYYYMMDD') CYRQ00,TO_DATE(QZRQ00,'YYYYMMDD') QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=:1 342 09:37:48 SQL Data In: ORACLE - Param = 1, Name = , Type = fldFLOAT, Precision = 0, Scale = 0, Data = 340327.000000 343 09:37:48 SQL Execute: ORACLE - SELECT BAH000,BRXM00,ZYH000,ZYCS00,BRXB00,TO_DATE(RYRQ00,'YYYYMMDD') RYRQ00,TO_DATE(CYRQ00,'YYYYMMDD') CYRQ00,TO_DATE(QZRQ00,'YYYYMMDD') QZRQ00,BRXB00,BAZT00,LSH000 FROM BA_BRZYXX WHERE LSH000=? 344 09:37:48 SQL Misc: ORACLE - Set rowset size 345 09:37:48 SQL Stmt: ORACLE - Fetch 346 09:37:48 SQL Stmt: ORACLE - EOF 347 09:37:48 SQL Data Out: ORACLE - Column = 1, Name = BAH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1101601 348 09:37:48 SQL Data Out: ORACLE - Column = 2, Name = BRXM00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 杨万春 349 09:37:48 SQL Data Out: ORACLE - Column = 3, Name = ZYH000, Type = fldZSTRING, Precision = 20, Scale = 0, Data = 1101601 350 09:37:48 SQL Data Out: ORACLE - Column = 4, Name = ZYCS00, Type = fldFLOAT, Precision = 2, Scale = 0, Data = 1.000000 351 09:37:48 SQL Data Out: ORACLE - Column = 5, Name = BRXB00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 男 352 09:37:48 SQL Data Out: ORACLE - Column = 6, Name = RYRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 7/7/2011 0:0:0:0 353 09:37:48 SQL Data Out: ORACLE - Column = 7, Name = CYRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 8/4/2011 0:0:0:0 354 09:37:48 SQL Data Out: ORACLE - Column = 8, Name = QZRQ00, Type = fldTIMESTAMP, Precision = 1, Scale = 0, Data = 7/7/2011 0:0:0:0 355 09:37:48 SQL Data Out: ORACLE - Column = 9, Name = BRXB00, Type = fldZSTRING, Precision = 16, Scale = 0, Data = 男 356 09:37:48 SQL Data Out: ORACLE - Column = 10, Name = BAZT00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 2 357 09:37:48 SQL Data Out: ORACLE - Column = 11, Name = LSH000, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 340327.000000