1 15:56:17 SQL Execute: ORACLE - select FBMC00,FBBH00 from vw_bm_brfbb0 where FBBH00=99 2 15:56:17 SQL Data Out: ORACLE - Column = 1, Name = FBMC00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 体检 3 15:56:17 SQL Data Out: ORACLE - Column = 2, Name = FBBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 99.000000 4 15:56:17 SQL Execute: ORACLE - select a.*, (select ickh00 from IC_YHXX00 where brid00=a.brid00 and rownum=1) ickh00,(select max(ghh000) from SF_BRXXB0 where brid00=a.brid00) ghh000 from BM_TYDWB0 a where dwxz00='1' and dwid00<>0 AND YYID00 = '220035' AND XTDMBZ = 'T' order by DWQYRQ DESC 5 15:56:17 SQL Data Out: ORACLE - Column = 1, Name = DWID00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1333.000000 6 15:56:17 SQL Data Out: ORACLE - Column = 2, Name = DWBH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 00029 7 15:56:17 SQL Data Out: ORACLE - Column = 3, Name = DWMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 省公务员2012 8 15:56:17 SQL Data Out: ORACLE - Column = 4, Name = DWQC00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = 省公务员 9 15:56:17 SQL Data Out: ORACLE - Column = 5, Name = PY0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = sgwy2012 10 15:56:17 SQL Data Out: ORACLE - Column = 6, Name = WB0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = iwtk2012 11 15:56:17 SQL Data Out: ORACLE - Column = 7, Name = DWZH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 12 15:56:17 SQL Data Out: ORACLE - Column = 8, Name = KHYH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 13 15:56:17 SQL Data Out: ORACLE - Column = 9, Name = DWZL00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 机关事业 14 15:56:17 SQL Data Out: ORACLE - Column = 10, Name = DWBXLX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 15 15:56:17 SQL Data Out: ORACLE - Column = 11, Name = DWBXBH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 00029 16 15:56:17 SQL Data Out: ORACLE - Column = 12, Name = DWQYRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120412 17 15:56:17 SQL Data Out: ORACLE - Column = 13, Name = DWQYSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:58:22 18 15:56:17 SQL Data Out: ORACLE - Column = 14, Name = DWTZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 19 15:56:17 SQL Data Out: ORACLE - Column = 15, Name = DWTZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 20 15:56:17 SQL Data Out: ORACLE - Column = 16, Name = DWQX00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 21 15:56:17 SQL Data Out: ORACLE - Column = 17, Name = DWFR00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 22 15:56:17 SQL Data Out: ORACLE - Column = 18, Name = DWDH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 23 15:56:17 SQL Data Out: ORACLE - Column = 19, Name = DWDZ00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 24 15:56:17 SQL Data Out: ORACLE - Column = 20, Name = DWYB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 25 15:56:17 SQL Data Out: ORACLE - Column = 21, Name = SFYX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 26 15:56:17 SQL Data Out: ORACLE - Column = 22, Name = DWBZ00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 27 15:56:17 SQL Data Out: ORACLE - Column = 23, Name = JZXE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 999999.000000 28 15:56:17 SQL Data Out: ORACLE - Column = 24, Name = JZKYJE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 29 15:56:17 SQL Data Out: ORACLE - Column = 25, Name = CZY000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1057.000000 30 15:56:17 SQL Data Out: ORACLE - Column = 26, Name = CZYXM0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 管理员 31 15:56:17 SQL Data Out: ORACLE - Column = 27, Name = CZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120412 32 15:56:17 SQL Data Out: ORACLE - Column = 28, Name = CZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:58:22 33 15:56:17 SQL Data Out: ORACLE - Column = 29, Name = FBBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 99.000000 34 15:56:17 SQL Data Out: ORACLE - Column = 30, Name = DWXZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 35 15:56:17 SQL Data Out: ORACLE - Column = 31, Name = DWLXR0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 36 15:56:17 SQL Data Out: ORACLE - Column = 32, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 37 15:56:17 SQL Data Out: ORACLE - Column = 33, Name = DWZKL0, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 100.000000 38 15:56:17 SQL Data Out: ORACLE - Column = 34, Name = DWTJCS, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 1.000000 39 15:56:17 SQL Data Out: ORACLE - Column = 35, Name = SFJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 40 15:56:17 SQL Data Out: ORACLE - Column = 36, Name = YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 220035 41 15:56:17 SQL Data Out: ORACLE - Column = 37, Name = XTDMBZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = T 42 15:56:17 SQL Data Out: ORACLE - Column = 38, Name = ICKH00, Type = fldZSTRING, Precision = 220, Scale = 0, Data = NULL 43 15:56:17 SQL Data Out: ORACLE - Column = 39, Name = GHH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = NULL 44 15:56:17 SQL Data Out: ORACLE - Column = 1, Name = DWID00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1304.000000 45 15:56:17 SQL Data Out: ORACLE - Column = 2, Name = DWBH00, Type = fldZSTRING, Precision = 10, Scale = 0, Data = 00028 46 15:56:17 SQL Data Out: ORACLE - Column = 3, Name = DWMC00, Type = fldZSTRING, Precision = 100, Scale = 0, Data = 电广传媒 47 15:56:17 SQL Data Out: ORACLE - Column = 4, Name = DWQC00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = 电广传媒 48 15:56:17 SQL Data Out: ORACLE - Column = 5, Name = PY0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = dgcm 49 15:56:17 SQL Data Out: ORACLE - Column = 6, Name = WB0000, Type = fldZSTRING, Precision = 10, Scale = 0, Data = jywv 50 15:56:17 SQL Data Out: ORACLE - Column = 7, Name = DWZH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 51 15:56:17 SQL Data Out: ORACLE - Column = 8, Name = KHYH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 52 15:56:17 SQL Data Out: ORACLE - Column = 9, Name = DWZL00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 机关事业 53 15:56:17 SQL Data Out: ORACLE - Column = 10, Name = DWBXLX, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 54 15:56:17 SQL Data Out: ORACLE - Column = 11, Name = DWBXBH, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 00028 55 15:56:17 SQL Data Out: ORACLE - Column = 12, Name = DWQYRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120313 56 15:56:17 SQL Data Out: ORACLE - Column = 13, Name = DWQYSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:23:27 57 15:56:17 SQL Data Out: ORACLE - Column = 14, Name = DWTZRQ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 58 15:56:17 SQL Data Out: ORACLE - Column = 15, Name = DWTZSJ, Type = fldZSTRING, Precision = 8, Scale = 0, Data = NULL 59 15:56:17 SQL Data Out: ORACLE - Column = 16, Name = DWQX00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 60 15:56:17 SQL Data Out: ORACLE - Column = 17, Name = DWFR00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 61 15:56:17 SQL Data Out: ORACLE - Column = 18, Name = DWDH00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 62 15:56:17 SQL Data Out: ORACLE - Column = 19, Name = DWDZ00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 63 15:56:17 SQL Data Out: ORACLE - Column = 20, Name = DWYB00, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 64 15:56:17 SQL Data Out: ORACLE - Column = 21, Name = SFYX00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = Y 65 15:56:17 SQL Data Out: ORACLE - Column = 22, Name = DWBZ00, Type = fldZSTRING, Precision = 200, Scale = 0, Data = NULL 66 15:56:17 SQL Data Out: ORACLE - Column = 23, Name = JZXE00, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 999999.000000 67 15:56:17 SQL Data Out: ORACLE - Column = 24, Name = JZKYJE, Type = fldFLOAT, Precision = 12, Scale = 2, Data = 0.000000 68 15:56:17 SQL Data Out: ORACLE - Column = 25, Name = CZY000, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1214.000000 69 15:56:17 SQL Data Out: ORACLE - Column = 26, Name = CZYXM0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = 张宗婵 70 15:56:17 SQL Data Out: ORACLE - Column = 27, Name = CZRQ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 20120313 71 15:56:17 SQL Data Out: ORACLE - Column = 28, Name = CZSJ00, Type = fldZSTRING, Precision = 8, Scale = 0, Data = 09:23:27 72 15:56:17 SQL Data Out: ORACLE - Column = 29, Name = FBBH00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 99.000000 73 15:56:17 SQL Data Out: ORACLE - Column = 30, Name = DWXZ00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = 1 74 15:56:17 SQL Data Out: ORACLE - Column = 31, Name = DWLXR0, Type = fldZSTRING, Precision = 30, Scale = 0, Data = NULL 75 15:56:17 SQL Data Out: ORACLE - Column = 32, Name = BRID00, Type = fldFLOAT, Precision = 10, Scale = 0, Data = 0.000000 76 15:56:17 SQL Data Out: ORACLE - Column = 33, Name = DWZKL0, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 100.000000 77 15:56:17 SQL Data Out: ORACLE - Column = 34, Name = DWTJCS, Type = fldFLOAT, Precision = 3, Scale = 0, Data = 2.000000 78 15:56:17 SQL Data Out: ORACLE - Column = 35, Name = SFJS00, Type = fldZSTRING, Precision = 1, Scale = 0, Data = N 79 15:56:17 SQL Data Out: ORACLE - Column = 36, Name = YYID00, Type = fldZSTRING, Precision = 6, Scale = 0, Data = 220035 80 15:56:17 SQL Data Out: ORACLE - Column = 37, Name = XTDMBZ, Type = fldZSTRING, Precision = 2, Scale = 0, Data = T 81 15:56:17 SQL Data Out: ORACLE - Column = 38, Name = ICKH00, Type = fldZSTRING, Precision = 220, Scale = 0, Data = NULL 82 15:56:17 SQL Data Out: ORACLE - Column = 39, Name = GHH000, Type = fldZSTRING, Precision = 12, Scale = 0, Data = NULL 83 15:56:17 SQL Execute: ORACLE - select * from BM_DWBMWH where DWID00=1333 84 15:56:17 SQL Data Out: ORACLE - Column = 1, Name = DWID00, Type = fldFLOAT, Precision = 5, Scale = 0, Data = 1333.000000 85 15:56:17 SQL Data Out: ORACLE - Column = 2, Name = BMMC00, Type = fldZSTRING, Precision = 50, Scale = 0, Data = 未填报