| SQL Id | SQL Text |
|---|
| 0126cqufqzasp | SELECT t1.XZQQC, decode(to_char(t1.XQKSR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQKSR, 'YYYY-MM-DD')) XQKSR, decode(to_char(t1.XQJZR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQJZR, 'YYYY-MM-DD')) XQJZR, t2.pmll*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '1'), t1.XQHLL*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '2'), to_char(t1.SHRQ, 'YYYY-MM-DD'), DECODE(t1.XZQZLDM, '01', '·¢ÐÐÈËÑ¡ÔñȨ', '02', 'Ͷ×ÊÈËÑ¡ÔñȨ', NULL) XZQLX, DECODE(t1.XZQZLDM, '01', 'Callable', '02', 'Puttable', NULL) EXZQLX FROM ADB_DJ_ZQXZQ t1, ADB_DJ_ZQ t2 WHERE t1.zqdm = t2.zqdm and t1.ZQDM = '046001'order by t1.XZQQC |
| 068c4au9p98wv | SELECT GTTGZH FROM ADB_KHZH_GTTGZH ORDER BY GTTGZH |
| 0a5ctztds9fys |
INSERT /*+ BYPASS_RECURSIVE_CHECK */ INTO "ADS"."V_GKSC_ACCR_QZFSZ_ASST" SELECT RQ, --ÈÕÆÚ
SUM(M1) M1, --·â±ÕʽÄæ»Ø¹ºÀûÏ¢ÊÕÈë
SUM(M2) M2, --Âò¶ÏʽÄæ»Ø¹ºÀûÏ¢ÊÕÈë
SUM(M3) M3, --×Ô¶¯ÖÊѺÈÚ×ÊÀûÏ¢ÊÕÈë
SUM(M4) M4, --ÈÚȯÀûÏ¢ÊÕÈë
SUM(M5) M5, --ÑëÐгÖÓÐծȯÀûÏ¢ÊÕÈë
SUM(M6) M6, --·â±ÕʽÕý»Ø¹ºÀûÏ¢Ö§³ö
SUM(M7) M7, --Âò¶ÏʽÕý»Ø¹ºÀûÏ¢Ö§³ö
SUM(M8) M8, --ÑëÐÐƱ¾ÝÀûÏ¢Ö§³ö
SUM(M9) M9, --SLOͶ·ÅÀûÏ¢ÊÕÈë
SUM(M10) M10 --SLO»ØÁýÀûÏ¢Ö§³ö
FROM (
--»Ø¹ºÐÅÏ¢´¦Àí
SELECT D.RQ RQ,
(CASE WHEN A.ZTBYWZLDM = 'H2' THEN SUM(A.SJLX) ELSE 0 END) M1,
(CASE WHEN A.ZTBYWZLDM = 'H4' THEN SUM(A.SJLX) ELSE 0 END) M2,
0 M3,
0 M4,
0 M5,
(CASE WHEN A.ZTBYWZLDM = 'H1' THEN SUM(A.SJLX) ELSE 0 END) M6,
(CASE WHEN A.ZTBYWZLDM = 'H3' THEN SUM(A.SJLX) ELSE 0 END) M7,
0 M8,
(CASE WHEN A.ZTBYWZLDM = 'H6' THEN SUM(A.SJLX) ELSE 0 END) M9,
(CASE WHEN A.ZTBYWZLDM = 'H5' THEN SUM(A.SJLX) ELSE 0 END) M10
FROM ADB_FX_TBHZ A, ADB_GG_RQ D
WHERE D.RQ > A.DQJSJGR
and A.SJLX>0
GROUP BY D.RQ, A.ZTBYWZLDM
UNION ALL
--ÑëÐгÖÓÐȯ´¦Àí
SELECT D.RQ,
0 M1,
0 M2,
0 M3,
0 M4,
SUM(C.DFLX) M5,
0 M6,
0 M7,
0 M8,
0 M9,
0 M10
FROM
(SELECT A.CZRQ RQ, A.DFLX FROM ADB_SJ_ZHDFFXHZ A, ADB_DJ_ZQ B --Õý³£ÀûÏ¢
WHERE A.ZQDM = B.ZQDM
AND B.FXRTGZH<>'F0001000000'
AND A.ZQDM NOT IN ('4018', '4019', '9001', '9002', '9003')
and A.DFLX>0
and A.ZHBH='Z0001000000'
AND A.DFYCBZ IN ('0', '1')
/*UNION ALL
SELECT * FROM ADB_SJ_ZHDFFXHZ WHERE CASHIN_ACCR>0 --Ô¤²â*/
UNION ALL
SELECT X.BQJXR RQ, A.DFLX
FROM ADB_SJ_ZHDFFXHZ A, ADB_DJ_Z
Q B, ADB_DJ_ZQJXQCXX X --Õý³£ÀûÏ¢
WHERE A.ZQDM = B.ZQDM
AND A.ZQDM = X.ZQDM
AND A.CZRQ <= X.BQJXR+15
AND A.CZRQ > X.BQQXR
AND B.FXRTGZH <> 'F0001000000'
AND A.ZQDM IN ('4018', '4019', '9002', '9003')
AND A.DFLX>0
and A.ZHBH = 'Z0001000000'
AND A.DFYCBZ IN ('0', '1')
UNION ALL --Õý³£ÀûÏ¢
SELECT X.BQJXR, A.DFLX
FROM ADB_SJ_ZHDFFXHZ A, ADB_DJ_ZQ B, ADB_DJ_ZQJXQCXX X
WHERE A.ZQDM = B.ZQDM
AND A.ZQDM = X.ZQDM
AND A.CZRQ <= X.BQJXR+15
AND A.CZRQ > X.BQQXR
AND B.FXRTGZH <> 'F0001000000'
AND A.DFLX>0
AND A.CZRQ <= TO_DATE('20041201', 'YYYYMMDD')
AND A.ZQDM = '9001'
and A.ZHBH = 'Z0001000000'
AND A.DFYCBZ IN ('0', '1')
UNION ALL --Õý³£ÀûÏ¢
SELECT TO_DATE('20051201', 'YYYYMMDD'), A.DFLX
FROM ADB_SJ_ZHDFFXHZ A
WHERE A.CZRQ > TO_DATE('20041201', 'YYYYMMDD') and A.ZQDM = '9001' AND A.DFYCBZ IN ('0', '1')
) C, ADB_GG_RQ D
WHERE D.RQ > C.RQ AND D.RQ <= TO_DATE('20501231', 'YYYYMMDD')
GROUP BY D.RQ
UNION ALL
--ÑëÐÐƱ¾Ý´¦Àí
SELECT D.RQ,
0 M1,
0 M2,
0 M3,
0 M4,
0 M5,
0 M6,
0 M7,
SUM(C.DFLX) M8,
0 M9,
0 M10
FROM
(SELECT A.CZRQ RQ, A.DFLX FROM ADB_SJ_ZHDFFXHZ A, ADB_DJ_ZQ B
WHERE A.ZQDM = B.ZQDM AND A.DFLX>0
AND A.ZHBH<>'Z0001000000' AND B.FXRTGZH='F0001000000' AND A.DFYCBZ IN ('0', '1')
) C, ADB_GG_RQ D
WHERE D.RQ > C.RQ AND D.RQ <= TO_DATE('20501231', 'YYYYMMDD')
GROUP BY D.RQ
)
GROUP BY RQ
|
| 0cn5rqt0qhhn1 | BEGIN
SP_MLIST (:1, :2) ;
END;
|
| 0xwvqt6sfk6g4 | SELECT t1.XZQQC, decode(to_char(t1.XQKSR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQKSR, 'YYYY-MM-DD')) XQKSR, decode(to_char(t1.XQJZR, 'YYYY-MM-DD'), '1950-01-01', '', to_char(t1.XQJZR, 'YYYY-MM-DD')) XQJZR, t2.pmll*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '1'), t1.XQHLL*100, FN_CAL_KYYE(t1.zqdm, t1.SHRQ, '2'), to_char(t1.SHRQ, 'YYYY-MM-DD'), DECODE(t1.XZQZLDM, '01', '·¢ÐÐÈËÑ¡ÔñȨ', '02', 'Ͷ×ÊÈËÑ¡ÔñȨ', NULL) XZQLX, DECODE(t1.XZQZLDM, '01', 'Callable', '02', 'Puttable', NULL) EXZQLX FROM ADB_DJ_ZQXZQ t1, ADB_DJ_ZQ t2 WHERE t1.zqdm = t2.zqdm and t1.ZQDM = '040217'order by t1.XZQQC |
| 13vm906uuj5ch | select t.userloginid, t.userpassword, t.email, t.name, t1.xb, t.phone, t1.dhhm2, t.company from xt_sys_user t, sso_user_info t1 where t.userloginid=t1.yhm and trim(t.userloginid) ='leichengyao' |
| 18naypzfmabd6 | INSERT INTO MGMT_SYSTEM_PERFORMANCE_LOG (JOB_NAME, TIME, DURATION, MODULE, ACTION, IS_TOTAL, NAME, VALUE, CLIENT_DATA, HOST_URL) VALUES (:B9 , SYSDATE, :B8 , SUBSTR(:B7 , 1, 512), SUBSTR(:B6 , 1, 32), :B5 , SUBSTR(:B4 , 1, 128), SUBSTR(:B3 , 1, 128), SUBSTR(:B2 , 1, 128), SUBSTR(:B1 , 1, 256)) |
| 1gu8t96d0bdmu | select t.ts#, t.file#, t.block#, nvl(t.bobj#, 0), nvl(t.tab#, 0), t.intcols, nvl(t.clucols, 0), t.audit$, t.flags, t.pctfree$, t.pctused$, t.initrans, t.maxtrans, t.rowcnt, t.blkcnt, t.empcnt, t.avgspc, t.chncnt, t.avgrln, t.analyzetime, t.samplesize, t.cols, t.property, nvl(t.degree, 1), nvl(t.instances, 1), t.avgspc_flb, t.flbcnt, t.kernelcols, nvl(t.trigflag, 0), nvl(t.spare1, 0), nvl(t.spare2, 0), t.spare4, t.spare6, ts.cachedblk, ts.cachehit, ts.logicalread from tab$ t, tab_stats$ ts where t.obj#= :1 and t.obj# = ts.obj# (+) |
| 1qanz6dv2cz51 | UPDATE OPB_CLIENT_CONN SET LOGIN_TIME = :1 WHERE CNX_ID = :2 |
| 1qrfs7yfgggwm | select t2.CYSXDM || t2.CYXZDM dm, CYXZMS MS from ADB_GG_CYXZ t2 where t2.CYSXDM<>'00' union select t1.CYSXDM||'00' dm, CYSXMS MS from ADB_GG_CYSX t1 where t1.CYSXDM<>'00' order by dm |
| 20f5509zbj6a6 | INSERT /*+APPEND*/ INTO TMP_ADF_YWJC_ZHJYXX_03 ( RQ , TGZH , ZQYE , ZQZSZ ) SELECT /*+PARALLEL(t, 5)*/ T.RQ, T.ZHBH , SUM(T.TGME) AS ZQYE, SUM(T.TGQJSZ) AS ZQZSZ FROM ADB_ZW_ZHTGYE T WHERE T.KMDM LIKE '03%' AND T.KMDM <> '0300' AND T.RQ >= :B2 AND T.RQ <= :B1 -1 GROUP BY T.RQ, T.ZHBH |
| 2ksmus56bbgtg | DELETE FROM OPB_CLIENT_CONN WHERE CNX_ID = :1 |
| 2px3jbmn7xzur | INSERT INTO REP_TEMP (TJNY, LBBH, XMBH1, XMBH2, XMBH3, SL) SELECT :B1 , DECODE (A.GTTZZXZDM, '0', '1015', '1', '1015', '2', '1015', '3', '1014', '4', '1014', '5', '1014', '6', '1014', '7', '1014', '8', '1014', '9', '1018' ), '1201', DECODE (D.ZHXH, '0001', '1252', '0002', '1253', '0003', '1254' ), NULL, NVL (SUM (A.TGME), 0) FROM ADC_RHZ_GTTG A, V_ADB_DJ_ZQ B, ADB_GG_ZHZL D WHERE A.ZQDM = B.ZQDM AND B.BZDM='01' AND B.FXRTGZH = D.ZHBH AND D.ZHXH IN ('0001', '0002', '0003') GROUP BY DECODE (A.GTTZZXZDM, '0', '1015', '1', '1015', '2', '1015', '3', '1014', '4', '1014', '5', '1014', '6', '1014', '7', '1014', '8', '1014', '9', '1018' ), DECODE (D.ZHXH, '0001', '1252', '0002', '1253', '0003', '1254' ) |
| 3417tk7t789u9 | INSERT INTO OPB_REQ_REPLY (CNX_ID, REQUEST_ID, SEGMENT_NO, UTC_REQ_TIME, UTC_OBJECT_TIME, LINE_NO, CONTENT) VALUES (:1, :2, :3, :4, :5, :6, :7) |
| 34m3wwz9ua48r | SELECT SUBJ_NAME, SUBJ_ID, SUBJ_DESC, IS_SHARED, OWNER_ID, CREATION_TIME, FOLDER_ATTR, SUBJ_GID, CREATE_INFO, OBJVERSION, VERSION_STATUS, OS_USER FROM OPB_SUBJECT WHERE SUBJ_ID = :1 |
| 3am9cfkvx7gq1 | CALL MGMT_ADMIN_DATA.EVALUATE_MGMT_METRICS(:target_guid, :metric_guid, :metric_values) |
| 3fjgc69pa75qp | declare
v_date1 date;
v_date2 date;
begin
v_date1 := to_date('20140616', 'YYYYMMDD');
v_date2 := to_date('20140618', 'YYYYMMDD');
sp_adb_zhtgye_gxsz(v_date1, v_date2);
end; |
| 3ggfhkzsdagsk | select to_char(sysdate, 'mm/dd/yyyy hh24:mi:ss') from dual |
| 3px3rcn1xg0ft | BEGIN
SP_GKSC_M_VIEWS_REFRESH ;
END;
|
| 3syzbdxytjm51 | SELECT DBTYPE_ID, DATATYPE_NAME, NATIVE_DATATYPE, PM_DATATYPE, DEFAULT_PRECISION, DEFAULT_SCALE, PROP_FLAGS, PRINT_FLAGS, ORDER_NUM, OPB_OBJECT_ID FROM OPB_MMD_DATATYPE WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID |
| 3w4qs0tbpmxr6 | select con#, obj#, rcon#, enabled, nvl(defer, 0), spare2, spare3 from cdef$ where robj#=:1 |
| 3yp8hm8b5jbmx | SELECT GQRQ, YHJGZRQBZ FROM (SELECT TO_CHAR(RQ, 'YYYY-MM-DD') AS GQRQ, YHJGZRQBZ FROM ADB_GG_RQ WHERE TO_CHAR(RQ, 'YYYYMMDD') >= TO_CHAR(SYSDATE, 'YYYYMMDD') ORDER BY GQRQ ) WHERE ROWNUM <30 |
| 40h8waqz94jr4 | INSERT INTO ADB_TMP_ZW_QZQGZ SELECT :B1 , ZQJ.ZQDM, CASE WHEN SOU.ZQDM IS NULL THEN '10' ELSE SOU.LTCSDM END LTCSDM, CASE WHEN SOU.ZQDM IS NULL THEN FN_CAL_BJFJG(ZQJ.ZQDM, TO_CHAR(:B1 , 'yyyymmdd')) ELSE SOU.GJQJ END GJQJ, CASE WHEN SOU.ZQDM IS NULL THEN FN_CAL_BJFJG(ZQJ.ZQDM, TO_CHAR(:B1 , 'yyyymmdd')) - FN_CAL_YJLX(ZQJ.ZQDM, TO_CHAR(:B1 , 'yyyymmdd')) ELSE SOU.GJJJ END GJJJ, CASE WHEN SOU.ZQDM IS NULL THEN '1' ELSE '2' END SZJSFF, SYSDATE BIGXSJ, SOU.GJSYL FROM (SELECT GZRQ, ZQDM, LTCSDM, GJQJ, GJJJ, GJSYL FROM ADB_XXFW_GZLSSJ WHERE KXD = 'ÍƼö' AND GZRQ >= TO_DATE('20060301', 'yyyymmdd') AND GZRQ = :B1 ) SOU, (SELECT T1.ZQDM FROM ADB_DJ_ZQ T1, ADB_DJ_ZQFXZJZC T2 WHERE T1.DQR > :B1 AND T1.QXR <= :B1 AND T1.ZQDM=T2.ZQDM AND T2.ZJZCCS=0 ) ZQJ WHERE SOU.ZQDM(+) = ZQJ.ZQDM |
| 4jzw21gb4w5yk | SELECT REPOSITORY_ID, REPOSITORY_TYPE, DOMAIN_NAME, REPOSITORY_NAME, DB_USER, DB_PASSWD2, DB_ODBC_CONNECT, DB_NATIVE_CONNECT, DB_TYPE, HOSTNAME, PORTNUM, OBJVERSION, PCSF_DOMAIN FROM OPB_REPOSIT_INFO ORDER BY REPOSITORY_TYPE ASC |
| 4qzs9t20kbucp |
INSERT INTO ADC_RHZ_CYTGJYAHT (RQ, ZQDM, YWLBDM, HTBH, JG, QJ, MRME, MCME, DLRZH, YWZTDM, CYZHA, CYZHB, CYALBDM, CYAXZDM, CYBLBDM, CYBXZDM, LTCSDM, LTCSMC, GHSJ ) SELECT JGRQ, ZQDM, YWLBDM, HTBH, JG, QJ, MRME, MCME, DLRZH, YWZTDM, CYZHA, CYZHB, CYALBDM, CYAXZDM, CYBLBDM, CYBXZDM, LTCSDM, LTCSMC, GHSJ FROM ( SELECT A.JGRQ, B.ZQDM, C.ZQDM ZQDMC, A.YWLBDM, B.HTBH, FN_GETZQGZ(A.JGRQ, B.ZQDM, 1) JG, FN_GETZQGZ(A.JGRQ, B.ZQDM, 0) QJ, A.MRME, A.MCME, FN_GETDLRZH(A.CYZHA, A.JGRQ) DLRZH, B.YWZTDM, A.CYZHA, A.CYZHB, FN_GETCYYSXX(A.CYZHA, A.JGRQ, '01') CYALBDM, FN_GETCYYSXX(A.CYZHA, A.JGRQ, '03') CYAXZDM, FN_GETCYYSXX(A.CYZHB, A.JGRQ, '01') CYBLBDM, FN_GETCYYSXX(A.CYZHB, A.JGRQ, '03') CYBXZDM, FN_GETZQBGLTCS(B.ZQDM, A.JGRQ, '0') LTCSDM, FN_GETZQBGLTCS(B.ZQDM, A.JGRQ, '1') LTCSMC, B.GHSJ FROM (SELECT T1.HTBH, T1.YWLBDM, T1.JGRQ, T1.FQFTGZH CYZHA, T1.SQFTGZH CYZHB, 0 MRME, T1.ZQZE MCME FROM ADB_SJ_YWCL T1 WHERE T1.YWLBDM IN ('280', '290', '300', '310') AND T1.HTBH IN (SELECT HTBH FROM ADB_SJ_YWCL WHERE YWLBDM IN ('280', '290', '300', '310') AND TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') BETWEEN :B2 AND :B1 UNION SELECT HTBH FROM ADB_SJ_YWCLZQXX WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') BETWEEN :B2 AND :B1 ) UNION ALL SELECT T2.HTBH, T2.YWLBDM, T2.JGRQ, T2.SQFTGZH CYZHA, T2.FQFTGZH CYZHB, T2.ZQZE MRME, 0 MCME FROM ADB_SJ_YWCL T2 WHERE T2.YWLBDM IN ('280', '290', '300', '310') AND T2.HTBH IN (SELECT HTBH
FROM ADB_SJ_YWCL WHERE YWLBDM IN ('280', '290', '300', '310') AND TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') BETWEEN :B2 AND :B1 UNION SELECT HTBH FROM ADB_SJ_YWCLZQXX WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') BETWEEN :B2 AND :B1 )) A, (SELECT W.HTBH HTBH1, T.ZQDM, W.GHSJ, W.YWZTDM, MAX(W.HTBH) HTBH, SUM(T.ZQME) ZQME FROM ADB_SJ_YWCLZQXX T, ADB_SJ_YWCL W WHERE T.HTBH = W.HTBH GROUP BY W.HTBH, T.ZQDM, W.GHSJ, W.YWZTDM ) B, V_ADB_DJ_ZQ C WHERE A.HTBH = B.HTBH1 AND B.ZQDM = C.ZQDM(+) ) WHERE ZQDMC IS NOT NULL |
| 4r07kscxz39m0 | SELECT DBTYPE_ID, KEY_NAME, SRCTGT_FLAGS, KEY_FLAGS, ORDER_NUM, OPB_OBJECT_ID FROM OPB_MMD_KEYTYPE WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID |
| 57sdckjq1q99v | SELECT REPOSIT_NAME, REPOSIT_GID FROM OPB_REPOSIT WHERE RECID = 1 |
| 5d0jrbzdgjq3t | select t2.ZWBBMC ZWBBMC, t2.YWBBMC YWBBMC, t1.BBBH BBBH , t2.BBLB , BBNY, FBSJ, FBZT from ADF_BB_TJYBCC t1, ADF_BB_TJYBZL t2 where t1.BBBH=t2.BBBH and t1.FBZT='1' and BBNY = '201405' and t1.WJLX = 1 order by t2.bblb, t1.BBBH |
| 5m7v14kapkp6q | SELECT TO_CHAR(RQ, 'YYYY-MM-DD') AS GQRQ, YHJGZRQBZ FROM ADB_GG_RQ WHERE TO_CHAR(RQ, 'YYYYMMDD') <= TO_CHAR(SYSDATE, 'YYYYMMDD') ORDER BY GQRQ DESC |
| 5nr6dbt7360wj | select jlgxsj from jshq_gxsj_tbl where jshqlb = '1' |
| 5wcxvqkvd7x56 | SELECT distinct TBL$OR$IDX$PART$NUM("PAR_INDEX_SAMPLE_BOND", 0, 1, 0, "SCRQ") FROM (SELECT "C"."GZR" "SCRQ" FROM "INDEX_BUILD_INFO" "C" WHERE "C"."GZR"=TO_DATE(:B1, 'yyyymmdd') AND "C"."GZR"=TO_DATE(:B2, 'yyyymmdd') AND "C"."FHZT"='3') ORDER BY 1 |
| 5z24t4p6j5pq0 | SELECT REPOSITORY_NAME FROM OPB_REPOSIT_INFO |
| 6055cmz8wt0xv | SELECT DBTYPE_ID, DBSUBTYPE_ID, OBJECT_TYPE, ATTR_ID, ATTR_INDEX, OPB_OBJECT_ID FROM OPB_MMD_DBTY2WAVAL WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID, DBSUBTYPE_ID, OBJECT_TYPE, ATTR_ID, ATTR_INDEX |
| 62hgv87gbfdtk | SELECT MAX(T1.RQ) FROM ADB_ZW_ZHTGYE T1 WHERE T1.ZQDM = :B1 AND T1.KMDM LIKE '03%' AND T1.KMDM <> '0300' |
| 65n74bvx3vs46 | SELECT OBJECT_TYPE, OBJECT_SUBTYPE, OS_TYPE, LIBRARY_NAME, LIB_TYPE FROM OPB_MMD_LIBS WHERE COMPONENT_ID = :1 AND COMPONENT_TYPE = 1 |
| 6ss9jsrba6g2z | SELECT METAEXT_NAME, DATA_TYPE, MAX_LENGTH, OBJECT_TYPE, DBTYPE, SUBTYPE, PERMISSIONS, DEFAULT_VALUE, METAEXT_DESC, METAEXT_PROP, OPB_OBJECT_ID, OBJVERSION, LINE_NO FROM OPB_MMD_METAEXT WHERE VENDOR_ID = :1 AND DOMAIN_ID = :2 ORDER BY OBJECT_TYPE, DBTYPE, METAEXT_NAME, LINE_NO ASC |
| 6tyd1d8grx3ky |
INSERT INTO ADC_RHZ_CYXQJYAHT (RQ, HTBH, ZQDM, CYZHA, CYZHB, DLSZH, YWLBDM, JSFSDM, CJRQ, GHSJ, JGRQ, HTSCRQ, MRBS, MRME, MRBJE, MRZJE, MCBS, MCME, MCBJE, MCZJE, JJ, QJ, YJLX, SYL, JJJSJE, QJJSJE, ZQZE, HTJE, GZJJ, GZQJ, YWZTDM, CYALBDM, CYASXDM, CYAXZDM, CYADQDM, CYAZGDM, CYAZGMC, CYBLBDM, CYBSXDM, CYBXZDM, CYBDQDM, CYBZGDM, CYBZGMC, SBYYDM, ZLBH, LTCSDM, LTCSMC, ZHBZYCXZG, ZHAZYCXZG, SJGXSJ ) SELECT D.RQ, D.HTBH, D.ZQDM, D.CYZHA, MAX(D.CYZHB), MAX(D.DLSZH), MAX(D.YWLBDM), MAX(D.JSFSDM), MAX(D.CJRQ), MAX(D.GHSJ), MAX(D.JGRQ), MAX(D.HTSCRQ), SUM(D.MRBS), SUM(D.MRME), SUM(D.MRBJE), SUM(D.MRZJE), SUM(D.MCBS), SUM(D.MCME), SUM(D.MCBJE), SUM(D.MCZJE), MAX(D.JJ), MAX(D.QJ), MAX(D.YJLX), MAX(D.SYL), SUM(D.JJJSJE), SUM(D.QJJSJE), SUM(D.ZQZE), SUM(D.HTJE), MAX(D.GZJJ), MAX(D.GZQJ), MAX(D.YWZTDM), MAX(D.CYALBDM), MAX(D.CYASXDM), MAX(D.CYAXZDM), MAX(D.CYADQDM), MAX(D.CYAZGDM), MAX(D.CYAZGMC), MAX(D.CYBLBDM), MAX(D.CYBSXDM), MAX(D.CYBXZDM), MAX(D.CYBDQDM), MAX(D.CYBZGDM), MAX(D.CYBZGMC), MAX(D.SBYYDM), MAX(D.ZLBH), MAX(D.LTCSDM), MAX(D.LTCSMC), MAX(D.ZHBZYCXZG), MAX(D.ZHAZYCXZG), MAX(D.SJGXSJ) FROM (SELECT A.JGRQ RQ, B.HTBH HTBH, C.ZQDM ZQDM, A.CYZHA CYZHA, A.CYZHB CYZHB, FN_GETDLRZH(A.CYZHA, A.JGRQ) DLSZH, A.YWLBDM YWLBDM, A.JSFSDM JSFSDM, A.CJRQ CJRQ, A.GHSJ GHSJ, A.JGRQ JGRQ, A.HTSCRQ HTSCRQ, A.LQBS MRBS, A.LQ * B.ZQME MRME, A.LQ * B.ZQME * DECODE(C.ZQXZDM, '10', (SELECT
B1.BQBJZ FROM ADB_DJ_ZQJXQCXX B1 WHERE B1.ZQDM = C.ZQDM AND B1.BQQXR <= A.JGRQ AND B1.BQJXR > A.JGRQ), C.FXJG) / 100 MRBJE, A.LQBJ MRZJE, A.ZQBS MCBS, A.ZQ * B.ZQME MCME, A.ZQ * B.ZQME * DECODE(C.ZQXZDM, '10', (SELECT B1.BQBJZ FROM ADB_DJ_ZQJXQCXX B1 WHERE B1.ZQDM = C.ZQDM AND B1.BQQXR <= A.JGRQ AND B1.BQJXR > A.JGRQ), C.FXJG) / 100 MCBJE, A.ZQBJ MCZJE, A.JJJG JJ, A.QJJG QJ, A.YJLX YJLX, A.SYL SYL, A.JJJSJE JJJSJE, A.QJJSJE QJJSJE, A.ZQZE1 ZQZE, A.ZQBJ HTJE, FN_GETZQGZ(A.JGRQ, B.ZQDM, '1') GZJJ, FN_GETZQGZ(A.JGRQ, B.ZQDM, '0') GZQJ, B.YWZTDM, FN_GETCYYSXX(A.CYZHA, A.JGRQ, '01') CYALBDM, FN_GETCYYSXX(A.CYZHA, A.JGRQ, '02') CYASXDM, FN_GETCYYSXX(A.CYZHA, A.JGRQ, '03') CYAXZDM, FN_GETCYYSXX(A.CYZHA, A.JGRQ, '04') CYADQDM, FN_GETCYYSXX(A.CYZHA, A.JGRQ, '05') CYAZGDM, FN_GETCYYSXX(A.CYZHA, A.JGRQ, '06') CYAZGMC, FN_GETCYYSXX(A.CYZHB, A.JGRQ, '01') CYBLBDM, FN_GETCYYSXX(A.CYZHB, A.JGRQ, '02') CYBSXDM, FN_GETCYYSXX(A.CYZHB, A.JGRQ, '03') CYBXZDM, FN_GETCYYSXX(A.CYZHB, A.JGRQ, '04') CYBDQDM, FN_GETCYYSXX(A.CYZHB, A.JGRQ, '05') CYBZGDM, FN_GETCYYSXX(A.CYZHB, A.JGRQ, '06') CYBZGMC, A.SBYYDM SBYYDM, A.ZLBH ZLBH, FN_GETZQBGLTCS(B.ZQDM, A.JGRQ, '0') LTCSDM, FN_GETZQBGLTCS(B.ZQDM, A.JGRQ, '1') LTCSMC, FN_GETZYCXZG(A.CYZHB, A.JGRQ) ZHBZYCXZG, FN_GETZYCXZG(A.CYZHA, A.JGRQ) ZHAZYCXZG, :B3 SJGXSJ FROM (SELECT T2.HTBH, T2.JSFSDM, T2.YWLBDM, T2.JGRQ JGRQ, T2.FQFTGZH CYZHA, T2.SQFTGZH CYZHB, T2.JJJG, T2.QJJG, T2.YJLX, T2.SYL, 1 ZQBS, 1
ZQ, T2.HTJE ZQBJ, 0 LQBS, 0 LQ, 0 LQBJ, T2.ZQZE ZQZE1, T2.JJJSJE, T2.QJJSJE, T2.CJRQ, T2.GHSJ, T2.HTSCRQ HTSCRQ, T2.SBYYDM SBYYDM, T2.ZLBH FROM ADB_SJ_XQYWCL T2 WHERE HTBH IN (SELECT HTBH FROM ADB_SJ_XQYWCL WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') BETWEEN :B2 AND :B1 UNION SELECT HTBH FROM ADB_SJ_YWCLZQXX WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') BETWEEN :B2 AND :B1 ) UNION ALL SELECT T1.HTBH, T1.JSFSDM, T1.YWLBDM, T1.JGRQ JGRQ, T1.SQFTGZH CYZHA, T1.FQFTGZH CYZHB, T1.JJJG, T1.QJJG, T1.YJLX, T1.SYL, 0 ZQBS, 0 ZQ, 0 ZQBJ, 1 LQBS, 1 LQ, T1.HTJE LQBJ, T1.ZQZE ZQZE1, T1.JJJSJE, T1.QJJSJE, T1.CJRQ, T1.GHSJ, T1.HTSCRQ HTSCRQ, T1.SBYYDM SBYYDM, T1.ZLBH FROM ADB_SJ_XQYWCL T1 WHERE T1.HTBH IN (SELECT HTBH FROM ADB_SJ_XQYWCL WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') BETWEEN :B2 AND :B1 UNION SELECT HTBH FROM ADB_SJ_YWCLZQXX WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD' ) BETWEEN :B2 AND :B1 ) )A, (SELECT T.HTBH, T.ZQDM, W.YWZTDM, SUM(T.ZQME) ZQME FROM ADB_SJ_YWCLZQXX T, ADB_SJ_YWCL W WHERE T.HTBH = W.HTBH AND T.HTBH IN (SELECT HTBH FROM ADB_SJ_XQYWCL WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') BETWEEN :B2 AND :B1 UNION SELECT HTBH FROM ADB_SJ_YWCLZQXX WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') BETWEEN :B2 AND :B1 ) AND W.HTBH IN (SELECT HTBH FROM ADB_SJ_XQYWCL WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') BETWEEN :B2 AND :B1 UNION SELECT HTBH FROM ADB_SJ_YWCLZQXX
WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') BETWEEN :B2 AND :B1 ) GROUP BY T.HTBH, T.ZQDM, W.YWZTDM ) B, V_ADB_DJ_ZQ C WHERE A.HTBH = B.HTBH AND B.ZQDM = C.ZQDM(+) ) D WHERE D.ZQDM IS NOT NULL GROUP BY D.RQ, D.HTBH, D.ZQDM, D.CYZHA |
| 6xvp6nxs4a9n4 | select nvl(sum(space), 0) from recyclebin$ where ts# = :1 |
| 6ywy9pp4ch683 | select t.userloginid, t.userpassword, t.email, t.name, t1.xb, t.phone, t1.dhhm2, t.company from xt_sys_user t, sso_user_info t1 where t.userloginid=t1.yhm and trim(t.userloginid) ='efundshk' |
| 755dttk22c9vc | update sso_user_info set DXBZ ='2' where trim(yhm)='guihaiyang' |
| 7awu3s5qpytcf | select zjgjxx0_.ZJGJXX_ID as ZJGJXX1_51_, zjgjxx0_.YC_DEF_ID as YC2_51_, zjgjxx0_.ZJ_ID as ZJ3_51_, zjgjxx0_.DW_ID as DW4_51_, zjgjxx0_.BZQX as BZQX51_, zjgjxx0_.BZQXMS as BZQXMS51_, zjgjxx0_.GJ_VALUE as GJ7_51_, zjgjxx0_.WORK_TIME as WORK8_51_ from ZJGJXX zjgjxx0_ where zjgjxx0_.DW_ID='0013' order by zjgjxx0_.WORK_TIME desc |
| 7g02rq984qvxb | INSERT INTO TMP_ADF_YWJC_ZHJYXX_07 SELECT /*+PARALLEL(t, 5)*/ R.RQ, T.CYZHA AS ZHBH, S.JGLXDM AS JGLXDM, NVL(SUM(T.ZHGME), 0) AS DGHYE, NVL(SUM(T.NHGME), 0) AS DFSYE, NVL(SUM(T.ZHGZJE), 0) AS DFK, NVL(SUM(T.NHGZJE), 0) AS DSK FROM TMP_ADF_YWJC_ZHJYXX_04 T, ADB_GG_RQ R , TMP_YWJC_JGMAP S WHERE R.RQ >= :B2 AND R.RQ <= :B1 AND T.SQJYRQ <= R.RQ AND T.DQJYRQ > R.RQ AND T.CYASXDM = S.CYSXXZ AND S.MZLB = '01' GROUP BY R.RQ, T.CYZHA, S.JGLXDM UNION ALL SELECT /*+PARALLEL(t, 5)*/ R.RQ, T.CYZHA AS ZHBH, S.JGLXDM AS JGLXDM, NVL(SUM(T.ZHGME), 0) AS DGHYE, NVL(SUM(T.NHGME), 0) AS DFSYE, NVL(SUM(T.ZHGZJE), 0) AS DFK, NVL(SUM(T.NHGZJE), 0) AS DSK FROM TMP_ADF_YWJC_ZHJYXX_04 T, ADB_GG_RQ R , TMP_YWJC_JGMAP S WHERE R.RQ >= :B2 AND R.RQ <= :B1 AND T.SQJYRQ <= R.RQ AND T.DQJYRQ > R.RQ AND T.CYAXZDM = S.CYSXXZ AND S.MZLB = '02' GROUP BY R.RQ, T.CYZHA, S.JGLXDM |
| 7gc6t65nkh578 | SELECT FN_GETBFXQR_5D('1') FROM DUAL |
| 7jfvtx5a4svff | UPDATE OPB_TASK_INST_RUN SET END_TIME=:1, RUN_STATUS_CODE=:2, RUN_ERR_CODE =:3, RUN_ERR_MSG = :4, SERVER_NODE_NAME = :5 WHERE WORKFLOW_ID = :6 AND WORKFLOW_RUN_ID = :7 AND WORKLET_RUN_ID = :8 AND INSTANCE_ID = :9 AND FRAGMENT_ID = -1 |
| 7msxd2qjtsw05 | SELECT /*+ INDEX(tasks mgmt_collection_tasks_pk) */ * FROM MGMT_COLLECTION_TASKS TASKS WHERE TASK_ID = :B1 FOR UPDATE |
| 83taa7kaw59c1 | select name, intcol#, segcol#, type#, length, nvl(precision#, 0), decode(type#, 2, nvl(scale, -127/*MAXSB1MINAL*/), 178, scale, 179, scale, 180, scale, 181, scale, 182, scale, 183, scale, 231, scale, 0), null$, fixedstorage, nvl(deflength, 0), default$, rowid, col#, property, nvl(charsetid, 0), nvl(charsetform, 0), spare1, spare2, nvl(spare3, 0) from col$ where obj#=:1 order by intcol# |
| 84kfc4gq2z5vp |
INSERT INTO ADC_RHZ_ZQFXKSC (ZQDM, RQ, FXL, SZSC, LTCSDM, LTCSMC) SELECT YY.ZQDM, YY.RQ, YY.SJJE, YY.SZSC, FN_GETZQBGLTCS(YY.ZQDM, YY.RQ, '0'), FN_GETZQBGLTCS(YY.ZQDM, YY.RQ, '1') FROM (SELECT A.ZQDM, A.FXKSR RQ, NVL(SUM(CASE WHEN A.ZQDM ='100234' THEN 10000000000 WHEN A.ZQDM ='100235' THEN 16000000000 WHEN A.ZQDM ='100236' THEN 16000000000 ELSE A.BCSJFXE END), 0) SJJE, DECODE(A.FXFWDM, '10', 'ÒøÐмä', '20', '¹ñ̨', '30', '½»Ò×Ëù', '40', '½»Ò×Ëù', 'ÆäËû') SZSC FROM ADB_DJ_ZQFXZJZC A, V_ADB_DJ_ZQ F WHERE A.FXFWDM NOT IN ('50', '60', '70') AND A.ZQDM = F.ZQDM AND (A.ZQDM NOT IN ('100234', '100235', '100236') OR (A.ZQDM IN ('100234', '100235', '100236') AND A.ZJZCCS=0)) AND TO_CHAR(A.FXKSR, 'YYYYMMDD') || A.ZQDM IN (SELECT DISTINCT TO_CHAR(FXJSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD')>=:B1 UNION SELECT DISTINCT TO_CHAR(FXKSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD')>=:B1 ) GROUP BY A.ZQDM, A.FXKSR, DECODE(A.FXFWDM, '10', 'ÒøÐмä', '20', '¹ñ̨', '30', '½»Ò×Ëù', '40', '½»Ò×Ëù', 'ÆäËû') UNION ALL SELECT A.ZQDM, A.KSR RQ, YHJ SJJE, 'ÒøÐмä' SZSC FROM ADB_GG_KSCFXLS A WHERE A.KSR < TO_DATE('20041001', 'yyyymmdd') AND TO_CHAR(A.KSR, 'YYYYMMDD') || A.ZQDM IN (SELECT DISTINCT TO_CHAR(FXJSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 UNION SELECT DISTIN
CT TO_CHAR(FXKSR, 'YYYYMMDD'
) || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 ) UNION ALL SELECT A.ZQDM, A.KSR RQ, JYS SJJE, '½»Ò×Ëù' SZSC FROM ADB_GG_KSCFXLS A WHERE A.KSR < TO_DATE('20041001', 'yyyymmdd') AND TO_CHAR(A.KSR, 'YYYYMMDD') || A.ZQDM IN (SELECT DISTINCT TO_CHAR(FXJSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 UNION SELECT DISTINCT TO_CHAR(FXKSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 ) UNION ALL SELECT A.ZQDM, A.KSR RQ, GT SJJE, '¹ñ̨' SZSC FROM ADB_GG_KSCFXLS A WHERE A.KSR < TO_DATE('20041001', 'yyyymmdd') AND TO_CHAR(A.KSR, 'YYYYMMDD') || A.ZQDM IN (SELECT DISTINCT TO_CHAR(FXJSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 UNION SELECT DISTINCT TO_CHAR(FXKSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 ) UNION ALL SELECT A.ZQDM, B.FXJSR RQ, NVL(SUM(A.TGME), 0) SJJE, C.MS SZSC FROM V_ADB_ZW_ZHTGYE A, ADB_DJ_ZQFXZJZC B, ADB_GG_ZHZL C WHERE A.ZQDM = B.ZQDM AND A.RQ = B.FXJSR AND A.ZHBH=C.ZHBH AND C.ZHLB='1' AND A.KMDM = '0401' AND B.FXFWDM IN ('50', '60', '70') AND (B.ZQDM NOT IN ('100234', '100235', '100236') OR (B.ZQDM IN ('100234', '100235', '100236') AND B.ZJZCCS=0)) AND A.RQ >= TO_DATE('20041001', 'yyyymmdd') AND TO_CHAR(A.RQ, 'YYYYMMDD') || A.ZQDM IN (
SELEC
T DISTINCT TO_CHAR(FXJSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 UNION SELECT DISTINCT TO_CHAR(FXKSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 ) GROUP BY A.ZQDM, B.FXJSR, C.MS UNION ALL SELECT A.ZQDM, B.FXJSR RQ, NVL(SUM(A.TGME), 0) SJJE, '¹ñ̨' SZSC FROM V_ADB_ZW_ZHTGYE A, ADB_DJ_ZQFXZJZC B, ADB_KHZH_YJTGZH C WHERE A.ZQDM = B.ZQDM AND A.RQ = B.FXJSR AND A.ZHBH = C.ZHBH AND C.ZHSXDM = '02' AND A.KMDM = '0401' AND B.FXFWDM IN ('50', '60', '70') AND (B.ZQDM NOT IN ('100234', '100235', '100236') OR (B.ZQDM IN ('100234', '100235', '100236') AND B.ZJZCCS=0)) AND A.RQ >= TO_DATE('20041001', 'yyyymmdd') AND A.ZHBH NOT IN (SELECT ZHBH FROM ADB_GG_ZHZL D WHERE D.ZHLB='1') AND TO_CHAR(A.RQ, 'YYYYMMDD') || A.ZQDM IN (SELECT DISTINCT TO_CHAR(FXJSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 UNION SELECT DISTINCT TO_CHAR(FXKSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 ) GROUP BY A.ZQDM, B.FXJSR UNION ALL SELECT T1.ZQDM, T1.RQ, (NVL(T2.SJJE, 0) - NVL(T3.SJJE, 0) - NVL(T4.SJJE, 0)) SJJE, 'ÒøÐмä' FROM (SELECT DISTINCT A.ZQDM, A.FXJSR RQ FROM ADB_DJ_ZQFXZJZC A WHERE TO_DATE(TO_CHAR(A.SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 UNION SELECT DISTINCT A.ZQDM, A.FXKSR RQ FROM ADB_DJ_ZQFXZJZC A WHERE TO_DATE(T
O_CHA
R(A.SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD')>=:B1 ) T1, (SELECT A.ZQDM, A.FXKSR RQ, NVL(SUM(CASE WHEN A.ZQDM ='100234' THEN 10000000000 WHEN A.ZQDM ='100235' THEN 16000000000 WHEN A.ZQDM ='100236' THEN 16000000000 ELSE A.BCSJFXE END), 0) SJJE FROM ADB_DJ_ZQFXZJZC A WHERE A.FXFWDM IN ('50', '60', '70') AND (A.ZQDM NOT IN ('100234', '100235', '100236') OR (A.ZQDM IN ('100234', '100235', '100236') AND A.ZJZCCS=0)) AND A.FXKSR >= TO_DATE('20041001', 'yyyymmdd') AND TO_CHAR(A.FXKSR, 'YYYYMMDD') || A.ZQDM IN (SELECT DISTINCT TO_CHAR(FXJSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 UNION SELECT DISTINCT TO_CHAR(FXKSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 ) GROUP BY ZQDM, A.FXKSR) T2, (SELECT A.ZQDM, B.FXJSR RQ, NVL(SUM(A.TGME), 0) SJJE FROM V_ADB_ZW_ZHTGYE A, ADB_DJ_ZQFXZJZC B, ADB_GG_ZHZL C WHERE A.ZQDM = B.ZQDM AND A.RQ = B.FXJSR AND A.ZHBH =C.ZHBH AND C.ZHLB='1' AND A.KMDM = '0401' AND B.FXFWDM IN ('50', '60', '70') AND (B.ZQDM NOT IN ('100234', '100235', '100236') OR (B.ZQDM IN ('100234', '100235', '100236') AND B.ZJZCCS=0)) AND A.RQ >= TO_DATE('20041001', 'yyyymmdd') AND TO_CHAR(A.RQ, 'YYYYMMDD') || A.ZQDM IN (SELECT DISTINCT TO_CHAR(FXJSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 UNION SELECT DISTINCT TO_CHAR(FXKSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJ
ZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 ) GROUP BY A.ZQDM, B.FXJSR) T3, (SELECT A.ZQDM, B.FXJSR RQ, NVL(SUM(A.TGME), 0) SJJE FROM V_ADB_ZW_ZHTGYE A, ADB_DJ_ZQFXZJZC B, ADB_KHZH_YJTGZH C WHERE A.ZQDM = B.ZQDM AND A.RQ = B.FXJSR AND A.ZHBH = C.ZHBH AND C.ZHSXDM = '02' AND A.KMDM = '0401' AND B.FXFWDM IN ('50', '60', '70') AND (B.ZQDM NOT IN ('100234', '100235', '100236') OR (B.ZQDM IN ('100234', '100235', '100236') AND B.ZJZCCS=0)) AND A.RQ >= TO_DATE('20041001', 'yyyymmdd') AND A.ZHBH NOT IN (SELECT ZHBH FROM ADB_GG_ZHZL WHERE ZHLB = '1') AND TO_CHAR(A.RQ, 'YYYYMMDD') || A.ZQDM IN (SELECT DISTINCT TO_CHAR(FXJSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 UNION SELECT DISTINCT TO_CHAR(FXKSR, 'YYYYMMDD') || ZQDM FROM ADB_DJ_ZQFXZJZC WHERE TO_DATE(TO_CHAR(SJGXSJ, 'YYYYMMDD'), 'YYYYMMDD') >=:B1 ) GROUP BY A.ZQDM, B.FXJSR) T4 WHERE T1.ZQDM = T2.ZQDM(+) AND T1.RQ = T2.RQ(+) AND T1.ZQDM = T3.ZQDM(+) AND T1.RQ = T3.RQ(+) AND T1.ZQDM = T4.ZQDM(+) AND T1.RQ = T4.RQ(+) AND (NVL(T2.SJJE, 0) <> 0 OR NVL(T3.SJJE, 0) <> 0 OR NVL(T4.SJJE, 0) <> 0)) YY |
| 85xjn04n39uwv | select fxjg, ZQZWDJR from ADC_TMP_CYFYZQFZ where zqdm = :1 |
| 8au9bv9krn4v4 |
INSERT INTO ZQW_ZHS_YB (RQ, TGZH, CYJC, SXBH, XZBH, LBBH, DLZHS, DLTGS, DLJSS) SELECT :B1 RQ, A.TGZH, E.KHJC, FN_GETCYYSXX(A.TGZH, :B1 , '02'), FN_GETCYYSXX(A.TGZH, :B1 , '03'), FN_GETCYYSXX(A.TGZH, :B1 , '01'), NVL(A.ZHS, 0), NVL(B.TGL, 0), NVL(C.JSL, 0) FROM (SELECT TGZH, COUNT(DLZH) ZHS FROM (SELECT T.ZHBH DLZH, :B1 RQ, FN_GETDLRZH(T.ZHBH, :B1 ) TGZH FROM ADB_KHZH_YJTGZH T WHERE T.KHRQ <= :B1 AND (T.ZXRQ >= :B1 OR T.ZXRQ IS NULL) AND FN_GETDLRZH(T.ZHBH, :B1 ) IS NOT NULL) GROUP BY TGZH) A, (SELECT DLRZH TGZH, SUM(TGME) TGL FROM V_ADB_ZW_ZHTGYE WHERE RQ = :B1 AND DLRZH IS NOT NULL AND KMDM LIKE '03%' AND KMDM <> '0300' GROUP BY DLRZH) B, (SELECT TGZH, SUM(ZQZE) JSL FROM (SELECT DLSZH TGZH, (MCME + MRME) ZQZE FROM ADC_RHZ_CYXQJYAHT WHERE TO_CHAR(RQ, 'YYYY') = TO_CHAR(:B1 , 'YYYY') AND RQ <= :B1 AND YWZTDM = '3' AND YWLBDM = '320' AND DLSZH IS NOT NULL UNION ALL SELECT DLSZH TGZH, (ZHGME +NHGME) ZQZE FROM ADC_RHZ_CYHGJYAHT WHERE TO_CHAR(SQJYRQ, 'YYYY') = TO_CHAR(:B1 , 'YYYY') AND SQJYRQ <= :B1 AND SQYWZTDM = '3' AND YWLBDM IN ('331', '341') AND DLSZH IS NOT NULL UNION ALL SELECT DLSZH TGZH, (MCME + MRME) ZQZE FROM ADC_RHZ_CYYQJYAHT WHERE TO_CHAR(RQ, 'YYYY') = TO_CHAR(:B1 , 'YYYY') AND RQ <= :B1 AND YWZTDM = '3' AND DLSZH IS NOT NULL) GROUP BY TGZH) C, ADB_KHZH_YJTGZH D, ADB_KHZH_KH E WHERE D.ZHBH = A.TGZH(+) AND D.ZHBH = B.TGZH(+) AND D.ZHBH = C.TGZH(+) AND D.KHBH=E.KHBH AND NVL(A.ZHS, 0) + NVL(B.TGL, 0) + N
VL(C.JSL, 0) > 0 |
| 8c48gv9dwt3a9 | BEGIN
P_ADC_TJXT_DATE_MAINTIANCE.SP_ADC_RHZ_CYTGJYAHT (:1, :2, :3) ;
END;
|
| 8kd7q720h6dhv | INSERT INTO OPB_CLIENT_CONN (CNX_ID, LOGIN_ID, CLIENT_TYPE, APP_NAME1, APP_NAME2, HOST_NAME, HOST_ADDR, HOST_PORT, PROCESS_ID, CNX_RESIL) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10) |
| 8kfsr67hxgrn2 | select t.userloginid, t.userpassword, t.email, t.name, t1.xb, t.phone, t1.dhhm2, t.company from xt_sys_user t, sso_user_info t1 where t.userloginid=t1.yhm and trim(t.userloginid) ='yxssh01' |
| 8ks2u43c1hg5s | SELECT DBTYPE_ID, IS_PLG, DBTYPE_NAME, BASE_ID, SRCTGT_FLAGS, H_FLAGS, E_FLAGS, I_FLAGS, DEFAULT_DBSUBTYPE, FIELD_SEPARATOR, NULL_STRING, NOTNULL_STRING, DSQ_TYPE, INVALID_CHARS, INVALID_FCHARS, OPB_OBJECT_ID FROM OPB_MMD_DBTYPE WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID |
| 8n14w3n9rtkuf | SELECT OBJECT_TYPE, OBJECT_SUBTYPE, OS_TYPE, LIBRARY_NAME, OPB_OBJECT_ID, LIB_TYPE, COMPONENT_ID FROM OPB_MMD_LIBS WHERE COMPONENT_TYPE = :1 AND COMPONENT_ID > :2 ORDER BY COMPONENT_ID |
| 8nq6h4nkk0jfp | SELECT FN_GETGZRQ('1') FROM DUAL |
| 8q4b6fjut4rpx | select to_char(max(t.end_time), 'yyyy-MM-dd hh24:mi:ss') etime, to_char(min(t.end_time), 'yyyy-MM-dd hh24:mi:ss') btime from etl_log_detail_cdctj t, (select max(etl_date) etl_max_date from etl_log_detail_cdctj where RUN_S_DATE = to_date('2014-05-01', 'yyyy-mm-dd')) t2 where proc_name in ('sp_ywzl01', 'sp_ywzl02', 'sp_fxdf', 'sp_fscfx', 'sp_zqzqqx', 'sp_zyzqrg', 'sp_zqdf', 'sp_zqtg', 'sp_tgqx', 'sp_fsctg', 'sp_ksctg', 'sp_zyzqtg', 'sp_zqtgz', 'sp_tzzsl', 'sp_yhxqjy_qz', 'sp_yhxqjy_tzz', 'sp_gtxqjy_qz', 'sp_yhzyjy_qz', 'sp_yhzyjy_tzz', 'sp_yhzyhg', 'sp_yhmdjy_qz', 'sp_yhmdjy_tzz', 'sp_yhmdh') and RUN_S_DATE = to_date('2014-05-01', 'yyyy-mm-dd') and etl_date = t2.etl_max_date |
| 8szc9vuqfx5qp | BEGIN
:rv := F_GETZZGZ (:1, :2) ;
END;
|
| 8uqgz38ysbtrt | DELETE FROM OPB_SERVICED_REQ WHERE CNX_ID = :1 |
| 8zsjj8d0p5zhb | SELECT DBTYPE_ID, DBSUBTYPE_ID, DBSUBTYPE_NAME, SRCTGT_FLAGS, H_FLAGS, E_FLAGS, I_FLAGS, OPB_OBJECT_ID FROM OPB_MMD_DBSUBTYPE WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID, DBSUBTYPE_ID |
| 90mcq66xcbj3k | DELETE FROM OPB_PROXYUSER_INFO WHERE CNX_ID = :1 |
| 9c7jpvndky794 | DELETE FROM OPB_REQ_REPLY WHERE CNX_ID = :1 |
| 9mx3suj8ks9q4 | SELECT ATTR_ID, ATTR_VALUE, LINE_NO, SESS_WIDG_INST_ID, PROC_INSTANCE_ID, PARTITION_ID, OBJECT_TYPE, OBJECT_SUBTYPE, COMP_VERSION FROM OPB_EXTN_ATTR WHERE SESSION_ID = :1 AND SESSION_INST_ID = :2 AND WORKFLOW_ID = :3 AND VERSION_NUMBER = :4 ORDER BY SESS_WIDG_INST_ID, PROC_INSTANCE_ID, PARTITION_ID, ATTR_ID, LINE_NO ASC |
| 9my85qydau25s | BEGIN
SP_MREPORT (:1, :2) ;
END;
|
| 9sd7fs6dr450r | update sso_user_info set DXBZ ='2' where trim(yhm)='shaoli' |
| 9tgj4g8y4rwy8 | select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0), NVL(bitmapranges, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3 |
| 9xd3hzz1t7cxa |
select * from(select trim(b.zqjc) || '£¨' || b1.zqdm || '£©' ZQDM, to_char(b1.BQQXR, 'yyyy/mm/dd') as rq, '2' as lx, b1.zqdm as dm FROM ADB_DJ_ZQJXQCXX B1, ADB_DJ_ZQ b Where to_char(B1.BQQXR, 'yyyy-mm-dd') = ('2014-06-17') AND B1.FXQC <> 1 AND B1.ZQDM not in (select zqdm from BJ_PBZQ where ZQCXBZ = 'Y') and b1.zqdm = b.zqdm union all Select trim(zqjc) || '£¨' || zqdm || '£©' ZQDM, to_char(b1.dqr, 'yyyy/mm/dd') as rq, '1' as lx, b1.zqdm as dm FROM ADB_DJ_ZQ¡¡B1 Where to_char(B1.DQR, 'yyyy-mm-dd') = ('2014-06-17') AND B1.ZQDM not in (select zqdm from BJ_PBZQ where ZQCXBZ = 'Y') union all SELECT trim(b.zqjc) || '£¨' || b1.zqdm || '£©' ZQDM, to_char(b1.hkrq, 'yyyy/mm/dd') as rq, '3' as lx, b.zqdm as dm FROM ADB_DJ_ZQHKRQ B1, ADB_DJ_ZQ b WHERE to_char(B1.HKRQ, 'yyyy-mm-dd') = ('2014-06-17') and B1.zqdm not in (select zqdm from BJ_PBZQ where ZQCXBZ = 'Y') and b1.zqdm = b.zqdm union all Select trim(t1.zqjc) || '£¨' || t1.zqdm || '£©' ZQDM, to_char(t.YHJSCLTR, 'yyyy/mm/dd') as rq, '4' as lx, t.zqdm as dm FROM ADB_DJ_ZQFXZJZC t, ADB_DJ_ZQ t1, ADB_DJ_ZQFZXX s1 where t.zqdm = t1.zqdm and t.ZJZCCS = 0 and to_char(t.YHJSCLTR, 'yyyy-mm-dd') = ('2014-06-17') and t.ZQDM not in (select zqdm from BJ_PBZQ where ZQCXBZ = 'Y') and t1.zqdm = s1.zqdm union all Select trim(t1.zqjc) || '£¨' || t1.zqdm || '£©' ZQDM, to_char(t.ZJZCRQ, 'yyyy/mm/dd') as rq, '6' as lx, t.zqdm as dm FROM ADB_DJ_ZQFXZJZC t, ADB_DJ_ZQ t1, ADB_DJ
_ZQFZXX s1
where t.zqdm = t1.zqdm and t.ZJZCCS > 0 and to_char(t.ZJZCRQ, 'yyyy-mm-dd') = ('2014-06-17') and t.ZQDM not in (select zqdm from BJ_PBZQ where ZQCXBZ = 'Y') and t1.zqdm = s1.zqdm union all SELECT TRIM(t1.zqjc) || '£¨' || t1.zqdm || '£©' ZQDM, to_char(t.xqksr, 'yyyy/mm/dd') || ' - ' || to_char(t.xqjzr, 'yyyy/mm/dd') as rq, '7' as lx, t.zqdm as dm FROM adb_dj_zqxzq t, ADB_DJ_ZQ t1 WHERE t.zqdm = t1.zqdm AND t.xzqzldm = '02' AND (to_char(t.xqksr, 'yyyy-mm-dd') = ('2014-06-17') OR '2014-06-17' between to_char(t.xqksr, 'yyyy-mm-dd') and to_char(t.xqjzr, 'yyyy-mm-dd')) AND t.ZQDM NOT IN (SELECT zqdm FROM BJ_PBZQ WHERE ZQCXBZ = 'Y') UNION ALL SELECT TRIM(t1.zqjc) || '£¨' || t1.zqdm || '£©' ZQDM, to_char(t.xqksr, 'yyyy/mm/dd') || ' - ' || to_char(t.xqjzr, 'yyyy/mm/dd') as rq, '8' as lx, t.zqdm as dm FROM adb_dj_zqxzq t, ADB_DJ_ZQ t1 WHERE t.zqdm = t1.zqdm AND t.xzqzldm = '03' AND (to_char(t.xqksr, 'yyyy-mm-dd') = ('2014-06-17') OR '2014-06-17' between to_char(t.xqksr, 'yyyy-mm-dd') and to_char(t.xqjzr, 'yyyy-mm-dd')) AND t.ZQDM NOT IN (SELECT zqdm FROM BJ_PBZQ WHERE ZQCXBZ = 'Y') UNION ALL SELECT TRIM(t1.zqjc) || '£¨' || t1.zqdm || '£©' ZQDM, to_char(t.xqksr, 'yyyy/mm/dd') || ' - ' || to_char(t.xqjzr, 'yyyy/mm/dd') as rq, '9' as lx, t.zqdm as dm FROM adb_dj_zqxzq t, ADB_DJ_ZQ t1 WHERE t.zqdm = t1.zqdm AND t.xzqzldm = '06' AND (to_char(t.xqksr, 'yyyy-mm-dd') = ('2014-06-17') OR '2014-06-17' between to_char(t.xqksr,
'yyyy
-mm-dd') and to_char(t.xqjzr, 'yyyy-mm-dd')) AND t.ZQDM NOT IN (SELECT zqdm FROM BJ_PBZQ WHERE ZQCXBZ = 'Y') order by rq, lx, dm) |
| a4gyt79jqj1vn | SELECT DBTYPE_ID, DBSUBTYPE_ID, OBJECT_TYPE, ATTR_ID, BIT_FLAGS, OPB_OBJECT_ID FROM OPB_MMD_DBTY2WATTR WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID, DBSUBTYPE_ID, OBJECT_TYPE, ATTR_ID |
| a7q4gu8xnaw83 | SELECT MAX(T.RQ) FROM ADB_GG_RQ T WHERE YHJGZRQBZ = '1' AND RQ <= :B1 |
| abtvgnm29jxvt | BEGIN
P_ADC_TJXT_DATE_MAINTIANCE.SP_ADC_RHZ_CYHGJYAHT (:1, :2, :3) ;
END;
|
| anwsc25ymp2z9 | BEGIN
P_ADF_TJXT_DATE_MAINTIANCE.SP_ADF_YWJC_ZHJYXX (:1, :2) ;
END;
|
| ap9gk365uf734 | BEGIN
GEN_BOND (:1, :2) ;
END;
|
| awusmrzdchg5x | SELECT FN_GETGZRQ('2') FROM DUAL |
| az5abyb2k37ka | INSERT INTO ADC_TMP1_CYFYZQFZ (ZQDM, ZQZWDJR) SELECT ZQDM, MIN(RQ) FROM ADB_ZW_ZHTGYE WHERE KMDM LIKE '03%' AND KMDM <> '0300' GROUP BY ZQDM |
| b4jvzzzfwv6gt |
INSERT INTO ADC_TMP_RJY_CYFY( GHSJ, JYRQ, ZQDM, ZHA, ZHB, YWLBBH, HTBH, BZ, MRME, MRJG, GZJJ, GZQJ, MCME, MCJG ) SELECT K.GHSJ, K.JYRQ, K.ZQDM, K.ZHA, K.ZHB, K.YWLBBH, K.HTBH, K.BZ, SUM(K.MRME), SUM(K.MRJG), SUM(K.GZJJ), SUM(K.GZQJ), SUM(K.MCME), SUM(K.MCJG) FROM ( SELECT T.SQGHSJ GHSJ, TO_DATE(TO_CHAR(T.SQGHSJ, 'YYYYMMDD'), 'YYYYMMDD') JYRQ, T.ZQDM ZQDM, T.CYZHB ZHA, T.CYZHA ZHB, T.YWLBDM YWLBBH, T.SQHTBH HTBH, B.BZDM BZ, T.ZHGME MRME, CASE WHEN T.ZHGME=0 THEN 0 ELSE ((T.ZHGZJE-FN_CAL_YJLX(T.ZQDM, TO_CHAR(T.SQGHSJ, 'YYYYMMDD')))/T.ZHGME)*100 END MRJG, FN_GETZQGZ(TO_DATE(TO_CHAR(T.SQGHSJ, 'YYYYMMDD'), 'YYYYMMDD'), T.ZQDM, 1) GZJJ, FN_GETZQGZ(TO_DATE(TO_CHAR(T.SQGHSJ, 'YYYYMMDD'), 'YYYYMMDD'), T.ZQDM, 0) GZQJ, 0 MCME, 0 MCJG FROM ADC_RHZ_CYHGJYAHT T, V_ADB_DJ_ZQ B, ADB_KHZH_YJTGZH C WHERE T.ZQDM=B.ZQDM AND T.CYZHB=C.ZHBH AND C.ZHSXDM='01' AND TO_DATE(TO_CHAR(T.SQGHSJ, 'YYYYMMDD'), 'YYYYMMDD')=:B1 AND T.ZHGBS!=0 AND (T.SQYWZTDM='3' OR T.DQYWZTDM = '3') AND T.YWLBDM IN ('331', '332') UNION ALL SELECT T.DQGHSJ, TO_DATE(TO_CHAR(T.DQGHSJ, 'YYYYMMDD'), 'YYYYMMDD'), T.ZQDM, T.CYZHB, T.CYZHA, T.YWLBDM, T.SQHTBH, B.BZDM BZ, T.NHGME, CASE WHEN T.NHGME=0 THEN 0 ELSE ((T.NHGZJE-FN_CAL_YJLX(T.ZQDM, TO_CHAR(T.DQGHSJ, 'YYYYMMDD')))/T.NHGME)*100 END , FN_GETZQGZ(TO_DATE(TO_CHAR(T.DQGHSJ, 'YYYYMMDD'), 'YYYYMMDD'), T.ZQDM, 1), FN_GETZQGZ(TO_DATE(TO_CHAR(T.DQGHSJ, 'YYYYMMDD'), 'YYYYMMDD'), T.ZQDM, 0), 0, 0 FROM ADC_RHZ_CYHGJYAHT T, V_ADB_DJ_ZQ B
, ADB_KHZH_YJTGZH C WHERE T.ZQDM=B.ZQDM AND T.CYZHB=C.ZHBH AND C.ZHSXDM='01' AND TO_DATE(TO_CHAR(T.DQGHSJ, 'YYYYMMDD'), 'YYYYMMDD')=:B1 AND T.NHGBS!=0 AND (T.SQYWZTDM='3' OR T.DQYWZTDM = '3') AND T.YWLBDM IN ('331', '332') UNION ALL SELECT T.SQGHSJ, TO_DATE(TO_CHAR(T.SQGHSJ, 'YYYYMMDD'), 'YYYYMMDD'), T.ZQDM, T.CYZHA, T.CYZHB, T.YWLBDM, T.SQHTBH, B.BZDM BZ, 0, 0 , FN_GETZQGZ(TO_DATE(TO_CHAR(T.SQGHSJ, 'YYYYMMDD'), 'YYYYMMDD'), T.ZQDM, 1), FN_GETZQGZ(TO_DATE(TO_CHAR(T.SQGHSJ, 'YYYYMMDD'), 'YYYYMMDD'), T.ZQDM, 0), T.ZHGME, CASE WHEN T.ZHGME=0 THEN 0 ELSE ((T.ZHGZJE-FN_CAL_YJLX(T.ZQDM, TO_CHAR(T.SQGHSJ, 'YYYYMMDD')))/T.ZHGME)*100 END FROM ADC_RHZ_CYHGJYAHT T, V_ADB_DJ_ZQ B, ADB_KHZH_YJTGZH C WHERE T.ZQDM=B.ZQDM AND T.CYZHA=C.ZHBH AND C.ZHSXDM='01' AND TO_DATE(TO_CHAR(T.SQGHSJ, 'YYYYMMDD'), 'YYYYMMDD')=:B1 AND T.ZHGBS!=0 AND (T.SQYWZTDM='3' OR T.DQYWZTDM = '3') AND T.YWLBDM IN ('331', '332') UNION ALL SELECT T.DQGHSJ, TO_DATE(TO_CHAR(T.DQGHSJ, 'YYYYMMDD'), 'YYYYMMDD'), T.ZQDM, T.CYZHA, T.CYZHB, T.YWLBDM, T.SQHTBH, B.BZDM BZ, 0, 0, FN_GETZQGZ(TO_DATE(TO_CHAR(T.DQGHSJ, 'YYYYMMDD'), 'YYYYMMDD'), T.ZQDM, 1), FN_GETZQGZ(TO_DATE(TO_CHAR(T.DQGHSJ, 'YYYYMMDD'), 'YYYYMMDD'), T.ZQDM, 0) , T.NHGME, CASE WHEN T.NHGME=0 THEN 0 ELSE ((T.NHGZJE-FN_CAL_YJLX(T.ZQDM, TO_CHAR(T.DQGHSJ, 'YYYYMMDD')))/T.NHGME)*100 END FROM ADC_RHZ_CYHGJYAHT T, V_ADB_DJ_ZQ B, ADB_KHZH_YJTGZH C WHERE T.ZQDM=B.ZQDM AND T.CYZHA=C.ZHBH AND C.ZHSXDM='01' AND TO_DATE(TO_CHAR(T.DQGHSJ, 'YYYYMMDD'), 'YYYYM
MDD')=:B1 AND T.NHGBS!=0 AND (T.SQYWZTDM='3' OR T.DQYWZTDM = '3') AND T.YWLBDM IN ('331', '332')) K GROUP BY K.GHSJ, K.JYRQ, K.ZQDM, K.ZHA, K.ZHB, K.YWLBBH, K.HTBH, K.BZ |
| ba7ydy9w2qw6j | SELECT COMP_ID, COMP_TYPE, COMP_VERSION, IS_OWNER, VENDOR_ID, PLG_ID, OPB_OBJECT_ID FROM OPB_MMD_PLGCOMP WHERE IS_REGISTERED = 1 ORDER BY COMP_TYPE, COMP_ID |
| bf58qknn64czr | INSERT /*+Append*/ INTO TMP_ADC_RHZ_CYHGJYAHT_03 NOLOGGING ( HTBH, ZQDM, CRBZ, ZQME, BZQZG, BZQLG, YWZTDM, YXZQME ) SELECT /*+parallel(w, 5) parallel(t, 5)*/ T.HTBH, T.ZQDM, MAX(DECODE(T.CRBZ, 'a', 0, 'b', 0, 1)) CRBZ, SUM(DECODE(T.CRBZ, 'a', 0, 'b', 0, T.ZQME)) ZQME, SUM(DECODE(T.CRBZ, 'a', T.ZQME, 0)) BZQZG, SUM(DECODE(T.CRBZ, 'b', T.ZQME, 0)) BZQLG, W.YWZTDM, SUM(DECODE(T.CRBZ, '0', T.ZQME, 0)) YXZQME FROM ADB_SJ_YWCL W, ADB_SJ_YWCLZQXX T WHERE T.HTBH = W.HTBH GROUP BY T.HTBH, T.ZQDM, W.YWZTDM |
| bn4b3vjw2mj3u |
SELECT OBJOID, CLSOID, DECODE(BITAND(FLAGS, 16384), 0, RUNTIME, LETIME), (2*PRI + DECODE(BITAND(STATUS, 4), 0, 0, decode(INST, :1, -1, 1))), JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM, INST_ID FROM ( select a.obj# OBJOID, a.class_oid CLSOID, a.next_run_date RUNTIME, a.last_enabled_time LETIME, a.flags FLAGS, a.job_status STATUS, 1 JOBTYPE, a.priority PRI, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, b.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, a.instance_id INST_ID from sys.scheduler$_job a, sys.scheduler$_program b, v$database v , v$instance i where a.program_oid = b.obj#(+) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select c.obj#, c.class_oid, c.next_run_date, c.last_enabled_time, c.flags, c.job_status, 1, decode(bitand(c.flags, 8589934592), 0, d.priority, pj.priority), decode(bitand(c.flags, 8589934592), 0, d.schedule_limit, decode(pj.s
chedule_limit, NULL, d.schedule_limit, pj.schedule_limit)), decode(bitand(c.flags, 8589934592), 0, d.job_weight, pj.job_weight), decode(c.running_instance, NULL, 0, c.running_instance), decode(bitand(c.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(c.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM, c.instance_id INST_ID from sys.scheduler$_lightweight_job c, sys.scheduler$_program d, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj, v$instance i where pj.obj# = c.obj# and pj.program_oid = d.obj#(+) and ( i.logins = 'ALLOWED' or bitand(c.flags, 17179869184) <> 0 ) and (:2 = 0 or c.running_instance = :3)) WHERE BITAND(STATUS, 515) = 1 AND BITAND(FLAGS, 1048576) = 0 AND ((BITAND(FLAGS, 134217728 + 268435456) = 0) OR (BITAND(STATUS, 1024) <> 0)) AND BITAND(FLAGS, 4096) = 0 AND (RUNTIME <= :4 OR
BITAND(FLAGS, 16384) <> 0) and ((CLSOID is not null and INST_ID is null and CLSOID in (select e.obj# from sys.scheduler$_class e where bitand(e.flags, :5) <> 0 and lower(e.affinity) = lower(:6))) or (INST_ID is not null and INST_ID = :7)) ORDER BY 3, 2, 4, 7 DESC, 1 |
| cb21bacyh3c7d | select metadata from kopm$ where name='DB_FDO' |
| cdxd8qnuyp79j | BEGIN
P_ADC_TJXT_DATE_MAINTIANCE.SP_ADC_RHZ_CYFY (:1, :2, :3) ;
END;
|
| cfnpcm9s12c51 | select t.userloginid, t.userpassword, t.email, t.name, t1.xb, t.phone, t1.dhhm2, t.company from xt_sys_user t, sso_user_info t1 where t.userloginid=t1.yhm and trim(t.userloginid) ='yinhuijuan' |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| crxwzb62uga8d | SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME, PRIORITY FROM QRTZ_TRIGGERS WHERE TRIGGER_STATE = :1 AND NEXT_FIRE_TIME < :2 AND (NEXT_FIRE_TIME >= :3 ) ORDER BY NEXT_FIRE_TIME ASC, PRIORITY DESC |
| csnp95dz2r8ss | select file#, block# from recyclebin$ where ts# = :1 and file# != 0 and block# != 0 and space = 0 |
| cw2xm0fdtnfsp |
select t.tjny, 'ÒøÐмäÊг¡' as xmmc, sum(sl) as sl , 1 orderNum from rep_tzzsl t where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t.xmbh2 = '1450' and t.lbbh not in ('1002', '1003', '1024') and t.xmbh1 = '1401' and t.xmbh3 = '1481' group by tjny union all select t.tjny, '¹ñ̨' as xmmc, sum(sl) as sl , 2 orderNum from rep_tzzsl t where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t.xmbh2 = '1455' and t.lbbh not in ('1002', '1003', '1024') and t.xmbh1 = '1401' and t.xmbh3 = '1482' group by tjny union all select a.tjny, a.xmmc, a.sl / 100000000 as sl , 3 orderNum from (select t1.sl, t1.tjny, t2.xmmc from rep_ywzl01 t1, rep_dim_xmzl t2 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = t2.xmbh and t1.xmbh1 = '0107') a union all select a.tjny, 'ÏÖȯ½»¸îÁ¿' as xmmc, a.sl / 100000000 as sl , 4 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl01 t1 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and
wjlx = '2'
and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 in ('0109', '0110') group by xmbh2, tjny) a union all select a.tjny, a.xmmc, a.sl / 100000000 as sl , 5 orderNum from (select t1.sl, t1.tjny, t2.xmmc from rep_ywzl01 t1, rep_dim_xmzl t2 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = t2.xmbh and t1.xmbh1 = '0109') a union all select a.tjny, a.xmmc, a.sl / 100000000 as sl , 6 orderNum from (select t1.sl, t1.tjny, t2.xmmc from rep_ywzl01 t1, rep_dim_xmzl t2 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = t2.xmbh and t1.xmbh1 = '0110') a union all select a.tjny, '»Ø¹º½»¸îÁ¿' as xmmc, a.sl / 100000000 as sl , 7 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl01 t1 where tjny = (select max(BBNY) from ADF_BB_TJYBCC
w
here FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 in ('0104', '0105') group by xmbh2, tjny) a union all select a.tjny, a.xmmc, a.sl / 100000000 as sl , 8 orderNum from (select t1.sl, t1.tjny, t2.xmmc from rep_ywzl01 t1, rep_dim_xmzl t2 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = t2.xmbh and t1.xmbh1 = '0104') a union all select a.tjny, a.xmmc, a.sl / 100000000 as sl , 9 orderNum from (select t1.sl, t1.tjny, t2.xmmc from rep_ywzl01 t1, rep_dim_xmzl t2 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = t2.xmbh and t1.xmbh1 = '0105') a union all select a.tjny, 'Ô¶Æڳɽ»Á¿' as xmmc, a.sl / 100000000 as sl , 10 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl01 t1 where tjny = (select max(BBNY)
from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = '0112' group by xmbh2, tjny) a union all select a.tjny, 'ծȯ¶Ò¸¶Á¿' as xmmc, a.sl / 100000000 as sl , 11 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl01 t1 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0151' and t1.xmbh3 = '0161' and t1.xmbh1 = '0106' group by xmbh2, tjny) a union all select a.tjny, 'ÍйÜÃæ¶î' as xmmc, a.sl / 100000000 as sl , 12 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl02 t1 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0251' and t1.xmbh1 = '0201' group by xmbh2, tjny) a union all select a.tjny, 'ÍйÜÊÐÖµ' as xmmc, a.sl / 100000000 as sl , 13 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl02 t1 where tjny = (select max(BBNY)
from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0251' and t1.xmbh1 = '0209' group by xmbh2, tjny) a union all select a.tjny, 'ÍйÜծȯ' as xmmc, a.sl / 100000000 as sl , 14 orderNum from (select sum(t1.sl) as sl, t1.tjny from rep_ywzl02 t1 where tjny = (select max(BBNY) from ADF_BB_TJYBCC where FBZT = '1' and wjlx = '2' and bbbh = '0101') and t1.xmbh2 = '0251' and t1.xmbh1 = '0205' group by xmbh2, tjny) a order by orderNum |
| cxrmzszkhd3sf |
SELECT T1.ZQJC, T.ZQDM, T5.JXMS, nvl(T.QQJG, -999), nvl(T.QCJG, -999), nvl(T.ZGJG, -999), nvl(T.ZDJG, -999), nvl(T.QMJG, -999), nvl(T.BQJG, -999), nvl(T.YJLX, -999), nvl(T.ZQJGL/10000, -999), nvl(T.ZJQSE/10000, -999), nvl(T.SYQX, -999), nvl(T.NSYL*100, -999), nvl(T.JSBS, -999), nvl(T.MBJSE/10000 , -999), nvl(T.BJE/10000 , -999), NVL(T3.SORTDM, '90') ZQXZSD, NVL(T4.SORTDM, '09') ZQFXRSD , NVL(T2.SORTDM, '03') FUXFSSD, T5.EJXMS, t6.xzqlx, t6.xzqxsr, t6.exzq, T7.ISIN, nvl(t.jsbs-t8.jsbs, -999) jsbsbz, t14.KHJC FROM XHJSHQ_tbl T, (select z1.ZQJC, z1.zqdm, z1.JXFSDM, z1.ZQXZDM, z2.ZQFXRDM, z1.FXRTGZH from ADB_DJ_ZQ z1 , ADB_DJ_ZQFZXX z2 where z1.zqdm=z2.zqdm) T1 , SORT_JXFS_TBL T2, SORT_ZQXZ_TBL T3, SORT_ZQFXR_TBL T4 , BJ_ZQJX T5, ADB_KHZH_YJTGZH t13, ADB_KHZH_KH t14, (SELECT t1.zqdm, DECODE(t1.XZQZLDM, '01', '·¢ÐÐÈËÑ¡ÔñȨ', '02', 'Ͷ×ÊÈËÑ¡ÔñȨ', NULL) XZQLX, to_char(t1.SHRQ, 'yyyy-mm-dd') XZQXSR, DECODE(t1.XZQZLDM, '01', 'Callable', '02', 'Putable', NULL) EXZQ FROM ADB_DJ_ZQXZQ t1, (SELECT t.zqdm, MAX(t.XZQQC) XZQQC FROM ADB_DJ_ZQXZQ t GROUP BY t.zqdm HAVING MAX(t.SHRQ) < trunc(SYSDATE) Union SELECT t.zqdm, MIN(t.XZQQC) XZQQC FROM ADB_DJ_ZQXZQ t WHERE t.SHRQ >= trunc(SYSDATE) GROUP BY t.zqdm) b WHERE t1.zqdm = b.zqdm AND t1.XZQQC = b.XZQQC) T6, T_ISIN T7, XHJSHQ_tbl_TEMP T8 where T.ZQDM = T1.ZQDM(+) AND T.ZQDM = T7.ZQDM(+) AND T1.JXFSDM = T2.DM(+) AND T1.ZQXZDM=T3.DM(+) AND T1.ZQFXRDM=trim(T4.DM(+)) AND T1.JXFSDM = T5.JXFSBH(+) and t.zq
dm=t6.zqdm(+
) AND t.zqdm=t8.zqdm(+) and t13.ZHBH = t1.FXRTGZH and t14.khbh = t13.khbh ORDER by ZQXZSD, ZQFXRSD, FUXFSSD, t.zqdm desc , t.zqjc asc , t5.jxms asc , T.ZQJGL asc , T.ZJQSE asc , T.SYQX asc , T.JSBS asc , T.MBJSE asc |
| cz1a1tjq1zuhc | SELECT DBTYPE_ID, DBSUBTYPE_ID, ATTR_ID, ATTR_NAME, ATTR_DESC, SRCTGT_FLAGS, IS_INT, PROP_FLAGS, OPB_OBJECT_ID FROM OPB_MMD_FLDATTR WHERE DBTYPE_ID > :1 ORDER BY DBTYPE_ID, DBSUBTYPE_ID |
| cz6fqtqpz054w | select t.userloginid, t.userpassword, t.email, t.name, t1.xb, t.phone, t1.dhhm2, t.company from xt_sys_user t, sso_user_info t1 where t.userloginid=t1.yhm and trim(t.userloginid) ='6546464' |
| d1xp1k85n3hrv | BEGIN
P_ADC_TJXT_DATE_MAINTIANCE.SP_ADC_RHZ_GTTG (:1, :2, :3) ;
END;
|
| d8mayxqw0wnpv | SELECT OWNER FROM DBA_PROCEDURES WHERE OBJECT_NAME = 'MGMT_USER' AND PROCEDURE_NAME = 'DROP_USER' |
| d9zyu1numxwaz | INSERT /*+APPEND*/ INTO TMP_ADF_YWJC_ZHJYXX_04 SELECT /*+PARALLEL(t, 5)*/ T.SQJYRQ, T.DQJYRQ, T.CYZHA, T.ZHGME, T.NHGME, T.ZHGME/A.ZQZME*A.DQJSJE, T.NHGME/A.ZQZME*A.DQJSJE, (SELECT TO_CHAR(MAX(S.CYSXDM)) FROM ADB_KHZH_TGZHCYSXLS S WHERE S.ZHBH=T.CYZHA AND S.KSRQ <= :B1 AND S.JSRQ > :B1 ), (SELECT TO_CHAR(MAX(S.CYXZDM)) FROM ADB_KHZH_TGZHCYXZLS S WHERE S.ZHBH=T.CYZHA AND S.KSRQ <= :B1 AND S.JSRQ > :B1 ) FROM ADC_RHZ_CYHGJYAHT T LEFT JOIN ADB_SJ_HGYWCL A ON T.SQHTBH = A.HTBH WHERE T.YWLBDM = '341' AND T.SQYWZTDM = '3' AND T.DQYWZTDM != 'C' AND (T.ZHGBS = 1 OR T.NHGBS = 1) AND T.DQJYRQ >= :B2 AND T.SQJYRQ <= :B1 |
| dqsmt5zbum41t | SELECT TO_CHAR(RQ, 'YYYY-MM-DD') AS GQRQ, YHJGZRQBZ FROM ADB_GG_RQ WHERE TO_CHAR(RQ, 'YYYYMMDD') >= TO_CHAR(SYSDATE, 'YYYYMMDD') ORDER BY GQRQ |
| ds58k4hks1fbx |
SELECT :B3 RQ, B.INDEX_DEF_ID YBZID, PAR.ZSMC YBZMC, G.BZDM DCQID, G.SJZDLXMS DCQMC, A.ZQDM LTCSZQDM, A.ZQMC LTCSZQJC, E.STDCODE CSBH, E.VALUEDESC CSJC, A.CYJJ + A.YJLX QJ, A.CYJJ JJ, A.YJLX, A.DQJGZDF ZDF, A.DCQ, A.GZSYL DQSYL, A.DCSYL DC, A.XZJQ, A.LLJQ, A.LCJQ, A.TX, A.LLTX, A.LCTX, A.JDJZ, A.TGL KLTCL, 0, ROUND(B.INDEX_SZQZ*100, 6) ZSSZQZ, A.SZQZ FROM ( SELECT * FROM (SELECT T.*, COUNT(*) OVER(PARTITION BY ZQDM, CSBH) CNT FROM (SELECT DISTINCT GZR, E.ZQDM, ZQMC, E.CSBH, CYJJ, YJLX, DQJGZDF, DCQ, GZSYL, DCSYL, XZJQ, LLJQ, LCJQ, TX, LLTX, LCTX, JDJZ, TGL, SZQZ, CYBS FROM INDEX_SAMPLEBOND_PRICE E WHERE GZR = TO_DATE(:B2 , 'yyyymmdd') ) T WHERE GZR = TO_DATE(:B2 , 'yyyymmdd')) WHERE CNT > 1 AND CYBS = '1' UNION ALL SELECT * FROM (SELECT T.* , COUNT(*) OVER(PARTITION BY ZQDM, CSBH) CNT FROM (SELECT DISTINCT GZR, E.ZQDM, ZQMC, E.CSBH, CYJJ, YJLX, DQJGZDF, DCQ, GZSYL, DCSYL, XZJQ, LLJQ, LCJQ, TX, LLTX, LCTX, JDJZ, TGL, SZQZ, CYBS FROM INDEX_SAMPLEBOND_PRICE E WHERE GZR = TO_DATE(:B2 , 'yyyymmdd') ) T WHERE GZR = TO_DATE(:B2 , 'yyyymmdd')) WHERE CNT = 1 ) A, (SELECT R.INDEX_DEF_ID, R.ZQDM, R.CSBH, R.SCRQ, R.DCQFDBS, R.INDEX_SZQZ FROM PAR_INDEX_SAMPLE_BOND R WHERE R.SCRQ = TO_DATE(:B2 , 'yyyymmdd') AND NOT EXISTS (SELECT T.INDEX_DEF_ID, T.GZR, T.ZQDM, T.CSBH FROM INDEX_BUILD_ERRBOND T WHERE T.GZR = R.SCRQ AND T.INDEX_DEF_ID = R.INDEX_DEF_ID AND T.ZQDM = R.ZQDM AND T.CSBH = R.CSBH) AND ( :B1 IS NUL
L OR :B1 = '@' OR R.INDEX_DEF_ID =:B1 )) B, INDEX_BUILD_INFO C, (SELECT TRIM(E2.SJZDLXDM) ENTRYVALUE, TRIM(E2.BZDM) STDCODE, TRIM(E2.SJZDLXMS) VALUEDESC FROM ADB_GG_UPDICTTYPE E1, ADB_GG_UPDICTITEM E2 WHERE TRIM(E1.SJZDLXDM) = TRIM(E2.SJZDXMDM) AND E1.SYBZ = '1' AND E2.SYBZ = '1' AND TRIM(E1.SJZDLXDM) = 'XXXZ1023') E, PAR_INDEX_DEF PAR, ( SELECT BZDM, SJZDLXMS, SJZDLXDM FROM ADB_GG_UPDICTITEM_TMP WHERE SJZDLXDM='0' )G WHERE A.ZQDM = B.ZQDM AND B.INDEX_DEF_ID = PAR.INDEX_DEF_ID AND ( :B1 IS NULL OR :B1 = '@' OR B.INDEX_DEF_ID =:B1 ) AND B.SCRQ = TO_DATE(:B2 , 'yyyymmdd') AND PAR.ZSZT = '2' AND PAR.GZFHZT = '3' AND PAR.FHZT = '3' AND PAR.GKBZ = '1' AND SYSDATE >= PAR.GKRQ AND A.CSBH = B.CSBH AND B.SCRQ = C.GZR AND C.FHZT = '3' AND TRIM(A.CSBH) = E.ENTRYVALUE(+) AND B.DCQFDBS IS NOT NULL ORDER BY YBZMC, LTCSZQDM |
| f9cnyyb2sp8y4 | UPDATE ADB_ZW_ZHTGYE A SET A.TGQJSZ = A.TGME * :B5 / 100, A.TGJJSZ = A.TGME * :B4 / 100, A.GZQJ = :B3 , A.GZJJ = :B2 , A.GJFSDM = :B1 WHERE TRIM(A.ZQDM) =TRIM(:B6 ) AND A.RQ = :B7 |
| f9nhvmc01gm4f | select ZHA, ZQDM, JYRQ, MRME, MRJG, GZJJ, GZQJ, MCME, MCJG, YWLBBH, HTBH, BZ from ADC_TMP_RJY_CYFY where ZHA = :1 and ZQDM = :2 and JYRQ = TO_DATE(:3, 'YYYY-MM-DD') order by GHSJ, HTBH |
| fstczk53pzw67 | BEGIN
rep_czb_tjjk.RUN_plan (:1, :2) ;
END;
|
| fwkk2a4j6davc | DELETE FROM OPB_OBJECT_LOCKS WHERE CNX_ID = :1 |
| g1uhxzx0ndqza |
SELECT :B4 RQ, B.INDEX_DEF_ID YBZID, PAR.ZSMC YBZMC, G.BZDM DCQID, G.SJZDLXMS DCQMC, A.ZQDM LTCSZQDM, A.ZQMC LTCSZQJC, E.STDCODE CSBH, E.VALUEDESC CSJC, A.CYJJ + A.YJLX QJ, A.CYJJ JJ, A.YJLX, A.DQJGZDF ZDF, A.DCQ, A.GZSYL DQSYL, A.DCSYL DC, A.XZJQ, A.LLJQ, A.LCJQ, A.TX, A.LLTX, A.LCTX, A.JDJZ, A.TGL KLTCL, B.DCQFDBS, ROUND(B.DCQ_SZQZ*100, 6) ZSSZQZ, A.SZQZ FROM ( SELECT * FROM (SELECT T.*, COUNT(*) OVER(PARTITION BY ZQDM, CSBH) CNT FROM (SELECT DISTINCT GZR, E.ZQDM, ZQMC, E.CSBH, CYJJ, YJLX, DQJGZDF, DCQ, GZSYL, DCSYL, XZJQ, LLJQ, LCJQ, TX, LLTX, LCTX, JDJZ, TGL, SZQZ, CYBS FROM INDEX_SAMPLEBOND_PRICE E WHERE GZR = TO_DATE(:B2 , 'yyyymmdd') ) T WHERE GZR = TO_DATE(:B2 , 'yyyymmdd')) WHERE CNT > 1 AND CYBS = '1' UNION ALL SELECT * FROM (SELECT T.* , COUNT(*) OVER(PARTITION BY ZQDM, CSBH) CNT FROM (SELECT DISTINCT GZR, E.ZQDM, ZQMC, E.CSBH, CYJJ, YJLX, DQJGZDF, DCQ, GZSYL, DCSYL, XZJQ, LLJQ, LCJQ, TX, LLTX, LCTX, JDJZ, TGL, SZQZ, CYBS FROM INDEX_SAMPLEBOND_PRICE E WHERE GZR = TO_DATE(:B2 , 'yyyymmdd') ) T WHERE GZR = TO_DATE(:B2 , 'yyyymmdd')) WHERE CNT = 1 ) A, (SELECT R.INDEX_DEF_ID, R.ZQDM, R.CSBH, R.SCRQ, R.DCQFDBS, R.DCQ_SZQZ FROM PAR_INDEX_SAMPLE_BOND R WHERE R.SCRQ = TO_DATE(:B2 , 'yyyymmdd') AND NOT EXISTS (SELECT T.INDEX_DEF_ID, T.GZR, T.ZQDM, T.CSBH FROM INDEX_BUILD_ERRBOND T WHERE T.GZR = R.SCRQ AND T.INDEX_DEF_ID = R.INDEX_DEF_ID AND T.ZQDM = R.ZQDM AND T.CSBH = R.CSBH) AND (:B1 IS
NULL OR :B1 = '@' OR R.INDEX_DEF_ID =:B1 )) B, INDEX_BUILD_INFO C, (SELECT TRIM(E2.SJZDLXDM) ENTRYVALUE, TRIM(E2.BZDM) STDCODE, TRIM(E2.SJZDLXMS) VALUEDESC FROM ADB_GG_UPDICTTYPE E1, ADB_GG_UPDICTITEM E2 WHERE TRIM(E1.SJZDLXDM) = TRIM(E2.SJZDXMDM) AND E1.SYBZ = '1' AND E2.SYBZ = '1' AND TRIM(E1.SJZDLXDM) = 'XXXZ1023') E, PAR_INDEX_DEF PAR, ( SELECT BZDM, SJZDLXMS, SJZDLXDM FROM ADB_GG_UPDICTITEM_TMP )G WHERE A.ZQDM = B.ZQDM AND B.INDEX_DEF_ID = PAR.INDEX_DEF_ID AND PAR.ZSZT = '2' AND PAR.GZFHZT = '3' AND PAR.FHZT = '3' AND PAR.GKBZ = '1' AND SYSDATE >= PAR.GKRQ AND ( :B1 IS NULL OR :B1 = '@' OR B.INDEX_DEF_ID =:B1 ) AND B.SCRQ = TO_DATE(:B2 , 'yyyymmdd') AND A.CSBH = B.CSBH AND B.SCRQ = C.GZR AND C.FHZT = '3' AND TRIM(A.CSBH) = E.ENTRYVALUE(+) AND G.SJZDLXDM=B.DCQFDBS AND B.DCQFDBS=:B3 AND B.DCQFDBS IS NOT NULL |
| g9r9mc97yphgh | SELECT BQQXR, NVL(BQZQNLL, 0) FROM ADB_DJ_ZQJXQCXX WHERE TRIM(ZQDM) = :B2 AND (BQQXR <= :B1 AND :B1 < BQJXR) |
| gcm4pj4n3a9wz | BEGIN
P_ADC_TJXT_DATE_MAINTIANCE.SP_ADC_RHZ_CYXQJYAHT (:1, :2, :3) ;
END;
|
| gjm43un5cy843 | SELECT SUM(USED), SUM(TOTAL) FROM (SELECT /*+ ORDERED */ SUM(D.BYTES)/(1024*1024)-MAX(S.BYTES) USED, SUM(D.BYTES)/(1024*1024) TOTAL FROM (SELECT TABLESPACE_NAME, SUM(BYTES)/(1024*1024) BYTES FROM (SELECT /*+ ORDERED USE_NL(obj tab) */ DISTINCT TS.NAME FROM SYS.OBJ$ OBJ, SYS.TAB$ TAB, SYS.TS$ TS WHERE OBJ.OWNER# = USERENV('SCHEMAID') AND OBJ.OBJ# = TAB.OBJ# AND TAB.TS# = TS.TS# AND BITAND(TAB.PROPERTY, 1) = 0 AND BITAND(TAB.PROPERTY, 4194400) = 0) TN, DBA_FREE_SPACE SP WHERE SP.TABLESPACE_NAME = TN.NAME GROUP BY SP.TABLESPACE_NAME) S, DBA_DATA_FILES D WHERE D.TABLESPACE_NAME = S.TABLESPACE_NAME GROUP BY D.TABLESPACE_NAME) |
| gtaur5b6ffp84 | select to_char(max(t.work_time), 'yyyymmdd') from curve_formula t, par_curve_type t1, yc_bd_info t2 where t1.yc_def_id = t2.yc_def_id and t.yc_id = t2.yc_id and t1.fbzt = 1 and t1.qxfl = 0 |
| Tablespace | Filename | Reads | Av Reads/s | Av Rd(ms) | Av Blks/Rd | Writes | Av Writes/s | Buffer Waits | Av Buf Wt(ms) |
|---|
| RN_TG_YE1998Y | +DATA/ads/datafile/rn_tg_ye1998y.324.756409629 |
109 | 0 | 25.69 | 68.57 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE1999Q1 | +DATA/ads/datafile/rn_tg_ye1999q1.325.756409647 |
65 | 0 | 11.69 | 32.25 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE1999Q2 | +DATA/ads/datafile/rn_tg_ye1999q2.326.756409681 |
70 | 0 | 14.14 | 37.27 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE1999Q3 | +DATA/ads/datafile/rn_tg_ye1999q3.327.756409681 |
49 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE1999Q4 | +DATA/ads/datafile/rn_tg_ye1999q4.328.756409683 |
49 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2000Q1 | +DATA/ads/datafile/rn_tg_ye2000q1.329.756409683 |
86 | 0 | 20.12 | 54.15 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2000Q2 | +DATA/ads/datafile/rn_tg_ye2000q2.330.756409685 |
92 | 0 | 20.11 | 57.59 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2000Q3 | +DATA/ads/datafile/rn_tg_ye2000q3.331.756409685 |
99 | 0 | 24.24 | 62.57 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2000Q4 | +DATA/ads/datafile/rn_tg_ye2000q4.332.756409687 |
108 | 0 | 24.63 | 68.02 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2001Q1 | +DATA/ads/datafile/rn_tg_ye2001q1.333.756409687 |
110 | 0 | 25.64 | 69.11 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2001Q2 | +DATA/ads/datafile/rn_tg_ye2001q2.334.756409687 |
122 | 0 | 28.44 | 76.98 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2001Q3 | +DATA/ads/datafile/rn_tg_ye2001q3.335.756409689 |
49 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2001Q4 | +DATA/ads/datafile/rn_tg_ye2001q4.336.756409689 |
140 | 0 | 30.21 | 81.73 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2002Q1 | +DATA/ads/datafile/rn_tg_ye2002q1.337.756409691 |
148 | 0 | 32.91 | 84.23 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2002Q2 | +DATA/ads/datafile/rn_tg_ye2002q2.338.756409691 |
164 | 0 | 32.93 | 88.50 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2002Q3 | +DATA/ads/datafile/rn_tg_ye2002q3.339.756409691 |
49 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2002Q4 | +DATA/ads/datafile/rn_tg_ye2002q4.340.756409693 |
49 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2003Q1 | +DATA/ads/datafile/rn_tg_ye2003q1.341.756409693 |
61 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2003Q2 | +DATA/ads/datafile/rn_tg_ye2003q2.342.756409695 |
249 | 0 | 39.12 | 95.35 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2003Q3 | +DATA/ads/datafile/rn_tg_ye2003q3.343.756409695 |
282 | 0 | 42.70 | 98.72 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2003Q4 | +DATA/ads/datafile/rn_tg_ye2003q4.344.756409695 |
290 | 0 | 37.41 | 99.53 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2004Q1 | +DATA/ads/datafile/rn_tg_ye2004q1.345.756409697 |
305 | 0 | 39.41 | 101.35 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2004Q2 | +DATA/ads/datafile/rn_tg_ye2004q2.346.756409697 |
322 | 0 | 39.16 | 102.36 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2004Q3 | +DATA/ads/datafile/rn_tg_ye2004q3.347.756409699 |
354 | 0 | 42.74 | 104.68 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2004Q4 | +DATA/ads/datafile/rn_tg_ye2004q4.348.756409699 |
378 | 0 | 44.31 | 106.16 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2005Q1 | +DATA/ads/datafile/rn_tg_ye2005q1.349.756409701 |
410 | 0 | 38.80 | 107.86 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2005Q2 | +DATA/ads/datafile/rn_tg_ye2005q2.350.756409701 |
61 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2005Q3 | +DATA/ads/datafile/rn_tg_ye2005q3.351.756409701 |
63 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2005Q4 | +DATA/ads/datafile/rn_tg_ye2005q4.352.756409703 |
490 | 0 | 42.04 | 111.15 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2006Q1 | +DATA/ads/datafile/rn_tg_ye2006q1.353.756409703 |
546 | 0 | 45.22 | 112.88 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2006Q2 | +DATA/ads/datafile/rn_tg_ye2006q2.354.756409705 |
626 | 0 | 42.70 | 114.81 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2006Q3 | +DATA/ads/datafile/rn_tg_ye2006q3.355.756409705 |
706 | 0 | 48.54 | 116.31 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2006Q4 | +DATA/ads/datafile/rn_tg_ye2006q4.356.756409705 |
770 | 0 | 46.91 | 117.28 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2007Q1 | +DATA/ads/datafile/rn_tg_ye2007q1.357.756409707 |
816 | 0 | 49.83 | 118.19 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2007Q2 | +DATA/ads/datafile/rn_tg_ye2007q2.358.756409707 |
913 | 0 | 48.90 | 119.10 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2007Q3 | +DATA/ads/datafile/rn_tg_ye2007q3.359.756409709 |
1,026 | 0 | 49.65 | 119.95 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2007Q4 | +DATA/ads/datafile/rn_tg_ye2007q4.360.756409709 |
1,154 | 0 | 43.25 | 120.85 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2008Q1 | +DATA/ads/datafile/rn_tg_ye2008q1.361.756409709 |
1,231 | 0 | 54.77 | 119.95 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2008Q2 | +DATA/ads/datafile/rn_tg_ye2008q2.362.756409711 |
1,360 | 0 | 54.68 | 120.62 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2008Q3 | +DATA/ads/datafile/rn_tg_ye2008q3.363.756409711 |
77 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2008Q4 | +DATA/ads/datafile/rn_tg_ye2008q4.364.756409713 |
1,616 | 0 | 42.40 | 121.79 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2009Q1 | +DATA/ads/datafile/rn_tg_ye2009q1.365.756409713 |
1,616 | 0 | 46.92 | 121.79 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2009Q2 | +DATA/ads/datafile/rn_tg_ye2009q2.366.756409713 |
1,742 | 0 | 48.98 | 122.39 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2009Q3 | +DATA/ads/datafile/rn_tg_ye2009q3.367.756409715 |
1,872 | 0 | 46.74 | 122.64 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2009Q4 | +DATA/ads/datafile/rn_tg_ye2009q4.368.756409715 |
1,939 | 0 | 45.66 | 122.63 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2010Q1 | +DATA/ads/datafile/rn_tg_ye2010q1.369.756409717 |
1,680 | 0 | 49.42 | 122.03 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2010Q2 | +DATA/ads/datafile/rn_tg_ye2010q2.370.756409717 |
1,232 | 0 | 51.83 | 119.86 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2010Q3 | +DATA/ads/datafile/rn_tg_ye2010q3.371.756409717 |
1,360 | 0 | 45.68 | 120.62 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2010Q4 | +DATA/ads/datafile/rn_tg_ye2010q4.372.756409719 |
1,678 | 0 | 50.55 | 122.17 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2011Q1 | +DATA/ads/datafile/rn_tg_ye2011q1.373.756409719 |
80 | 0 | 1.25 | 2.58 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2011Q2 | +DATA/ads/datafile/rn_tg_ye2011q2.374.756409721 |
3,603 | 0 | 50.44 | 125.11 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2011Q3 | +DATA/ads/datafile/rn_tg_ye2011q3.375.756409721 |
77 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2011Q4 | +DATA/ads/datafile/rn_tg_ye2011q4.376.756409723 |
80 | 0 | 1.88 | 3.36 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2012Q1 | +DATA/ads_primary/datafile/rn_tg_ye2012q1.614.769966953 |
84 | 0 | 1.67 | 3.25 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2012Q2 | +DATA/ads_primary/datafile/rn_tg_ye2012q2.615.769966955 |
84 | 0 | 2.02 | 3.25 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2012Q3 | +DATA/ads_primary/datafile/rn_tg_ye2012q3.627.787058153 |
82 | 0 | 1.71 | 3.30 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE2012Q4 | +DATA/ads_primary/datafile/rn_tg_ye2012q4.628.787058155 |
82 | 0 | 1.34 | 3.30 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX1998Y | +DATA/ads/datafile/rn_tg_ye_idx1998y.377.756409723 |
77 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX1999Q1 | +DATA/ads/datafile/rn_tg_ye_idx1999q1.378.756409723 |
77 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX1999Q2 | +DATA/ads/datafile/rn_tg_ye_idx1999q2.379.756409725 |
80 | 0 | 1.25 | 2.58 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX1999Q3 | +DATA/ads/datafile/rn_tg_ye_idx1999q3.380.756409725 |
80 | 0 | 1.13 | 2.58 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX1999Q4 | +DATA/ads/datafile/rn_tg_ye_idx1999q4.381.756409727 |
92 | 0 | 0.98 | 2.37 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2000Q1 | +DATA/ads/datafile/rn_tg_ye_idx2000q1.382.756409727 |
94 | 0 | 1.06 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2000Q2 | +DATA/ads/datafile/rn_tg_ye_idx2000q2.383.756409729 |
94 | 0 | 1.06 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2000Q3 | +DATA/ads/datafile/rn_tg_ye_idx2000q3.384.756409729 |
91 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2000Q4 | +DATA/ads/datafile/rn_tg_ye_idx2000q4.385.756409729 |
91 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2001Q1 | +DATA/ads/datafile/rn_tg_ye_idx2001q1.386.756409731 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2001Q2 | +DATA/ads/datafile/rn_tg_ye_idx2001q2.387.756409731 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2001Q3 | +DATA/ads/datafile/rn_tg_ye_idx2001q3.388.756409733 |
92 | 0 | 1.20 | 2.37 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2001Q4 | +DATA/ads/datafile/rn_tg_ye_idx2001q4.389.756409733 |
93 | 0 | 0.86 | 2.35 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2002Q1 | +DATA/ads/datafile/rn_tg_ye_idx2002q1.390.756409733 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2002Q2 | +DATA/ads/datafile/rn_tg_ye_idx2002q2.391.756409735 |
91 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2002Q3 | +DATA/ads/datafile/rn_tg_ye_idx2002q3.392.756409735 |
90 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2002Q4 | +DATA/ads/datafile/rn_tg_ye_idx2002q4.393.756409737 |
94 | 0 | 1.06 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2003Q1 | +DATA/ads/datafile/rn_tg_ye_idx2003q1.394.756409737 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2003Q2 | +DATA/ads/datafile/rn_tg_ye_idx2003q2.395.756409737 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2003Q3 | +DATA/ads/datafile/rn_tg_ye_idx2003q3.396.756409739 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2003Q4 | +DATA/ads/datafile/rn_tg_ye_idx2003q4.397.756409739 |
92 | 0 | 1.09 | 2.37 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2004Q1 | +DATA/ads/datafile/rn_tg_ye_idx2004q1.398.756409741 |
91 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2004Q2 | +DATA/ads/datafile/rn_tg_ye_idx2004q2.399.756409741 |
91 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2004Q3 | +DATA/ads/datafile/rn_tg_ye_idx2004q3.400.756409741 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2004Q4 | +DATA/ads/datafile/rn_tg_ye_idx2004q4.401.756409743 |
108 | 0 | 0.74 | 2.17 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2005Q1 | +DATA/ads/datafile/rn_tg_ye_idx2005q1.402.756409743 |
108 | 0 | 1.02 | 2.17 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2005Q2 | +DATA/ads/datafile/rn_tg_ye_idx2005q2.403.756409745 |
108 | 0 | 0.65 | 2.17 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2005Q3 | +DATA/ads/datafile/rn_tg_ye_idx2005q3.404.756409745 |
106 | 0 | 0.94 | 2.19 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2005Q4 | +DATA/ads/datafile/rn_tg_ye_idx2005q4.405.756409747 |
104 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2006Q1 | +DATA/ads/datafile/rn_tg_ye_idx2006q1.406.756409747 |
105 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2006Q2 | +DATA/ads/datafile/rn_tg_ye_idx2006q2.407.756409747 |
94 | 0 | 1.06 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2006Q3 | +DATA/ads/datafile/rn_tg_ye_idx2006q3.408.756409749 |
93 | 0 | 1.18 | 2.35 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2006Q4 | +DATA/ads/datafile/rn_tg_ye_idx2006q4.409.756409749 |
94 | 0 | 1.17 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2007Q1 | +DATA/ads/datafile/rn_tg_ye_idx2007q1.410.756409751 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2007Q2 | +DATA/ads/datafile/rn_tg_ye_idx2007q2.411.756409751 |
94 | 0 | 1.06 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2007Q3 | +DATA/ads/datafile/rn_tg_ye_idx2007q3.412.756409751 |
91 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2007Q4 | +DATA/ads/datafile/rn_tg_ye_idx2007q4.413.756409753 |
89 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2008Q1 | +DATA/ads/datafile/rn_tg_ye_idx2008q1.414.756409753 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2008Q2 | +DATA/ads/datafile/rn_tg_ye_idx2008q2.415.756409755 |
94 | 0 | 0.85 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2008Q3 | +DATA/ads/datafile/rn_tg_ye_idx2008q3.416.756409755 |
94 | 0 | 1.17 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2008Q4 | +DATA/ads/datafile/rn_tg_ye_idx2008q4.417.756409755 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2009Q1 | +DATA/ads/datafile/rn_tg_ye_idx2009q1.418.756409757 |
94 | 0 | 1.06 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2009Q2 | +DATA/ads/datafile/rn_tg_ye_idx2009q2.419.756409757 |
91 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2009Q3 | +DATA/ads/datafile/rn_tg_ye_idx2009q3.420.756409759 |
89 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2009Q4 | +DATA/ads/datafile/rn_tg_ye_idx2009q4.421.756409759 |
107 | 0 | 0.93 | 2.18 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2010Q1 | +DATA/ads/datafile/rn_tg_ye_idx2010q1.422.756409759 |
108 | 0 | 0.83 | 2.17 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2010Q2 | +DATA/ads/datafile/rn_tg_ye_idx2010q2.423.756409761 |
108 | 0 | 0.83 | 2.17 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2010Q3 | +DATA/ads/datafile/rn_tg_ye_idx2010q3.424.756409761 |
107 | 0 | 0.75 | 2.18 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2010Q4 | +DATA/ads/datafile/rn_tg_ye_idx2010q4.425.756409763 |
108 | 0 | 0.93 | 2.17 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2011Q1 | +DATA/ads/datafile/rn_tg_ye_idx2011q1.426.756409763 |
105 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2011Q2 | +DATA/ads/datafile/rn_tg_ye_idx2011q2.427.756409765 |
91 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2011Q3 | +DATA/ads/datafile/rn_tg_ye_idx2011q3.428.756409765 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| RN_TG_YE_IDX2011Q4 | +DATA/ads/datafile/rn_tg_ye_idx2011q4.429.756409765 |
92 | 0 | 0.87 | 2.37 | 14 | 0 | 0 | 0.00 |
| SYSAUX | +DATA/ads/datafile/sysaux.257.752265643 |
16,159 | 1 | 7.81 | 19.12 | 2,951 | 0 | 0 | 0.00 |
| SYSTEM | +DATA/ads/datafile/system.256.752265643 |
8,843 | 1 | 19.85 | 49.61 | 549 | 0 | 51 | 0.00 |
| SYSTEM | +DATA/ads/datafile/system.320.754314441 |
7,598 | 1 | 33.15 | 90.99 | 276 | 0 | 18 | 0.00 |
| TEMP | +DATA/ads/tempfile/temp.264.752265921 |
4 | 0 | 0.00 | 1.00 | 1 | 0 | 0 | |
| TEST | +DATA/ads/datafile/test.430.756410021 |
94 | 0 | 1.17 | 2.34 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE1998Y | +DATA/ads_primary/datafile/test_rn_tg_ye1998y.631.787919929 |
78 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE1999Q1 | +DATA/ads_primary/datafile/test_rn_tg_ye1999q1.632.787919931 |
78 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE1999Q2 | +DATA/ads_primary/datafile/test_rn_tg_ye1999q2.633.787919933 |
100 | 0 | 9.70 | 26.39 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE1999Q3 | +DATA/ads_primary/datafile/test_rn_tg_ye1999q3.634.787919935 |
92 | 0 | 6.41 | 17.55 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE1999Q4 | +DATA/ads_primary/datafile/test_rn_tg_ye1999q4.635.787919935 |
113 | 0 | 14.25 | 38.08 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2000Q1 | +DATA/ads_primary/datafile/test_rn_tg_ye2000q1.636.787919937 |
116 | 0 | 14.91 | 40.41 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2000Q2 | +DATA/ads_primary/datafile/test_rn_tg_ye2000q2.637.787919937 |
121 | 0 | 17.11 | 44.02 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2000Q3 | +DATA/ads_primary/datafile/test_rn_tg_ye2000q3.638.787919939 |
78 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2000Q4 | +DATA/ads_primary/datafile/test_rn_tg_ye2000q4.639.787919941 |
78 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2001Q1 | +DATA/ads_primary/datafile/test_rn_tg_ye2001q1.640.787919941 |
153 | 0 | 17.84 | 49.97 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2001Q2 | +DATA/ads_primary/datafile/test_rn_tg_ye2001q2.641.787919943 |
167 | 0 | 21.14 | 56.51 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2001Q3 | +DATA/ads_primary/datafile/test_rn_tg_ye2001q3.642.787919943 |
175 | 0 | 22.06 | 59.78 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2001Q4 | +DATA/ads_primary/datafile/test_rn_tg_ye2001q4.643.787919945 |
183 | 0 | 24.37 | 62.76 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2002Q1 | +DATA/ads_primary/datafile/test_rn_tg_ye2002q1.644.787919947 |
191 | 0 | 26.02 | 65.49 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2002Q2 | +DATA/ads_primary/datafile/test_rn_tg_ye2002q2.645.787919947 |
92 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2002Q3 | +DATA/ads_primary/datafile/test_rn_tg_ye2002q3.646.787919949 |
81 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2002Q4 | +DATA/ads_primary/datafile/test_rn_tg_ye2002q4.647.787919951 |
220 | 0 | 32.68 | 80.08 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2003Q1 | +DATA/ads_primary/datafile/test_rn_tg_ye2003q1.648.787919951 |
236 | 0 | 31.69 | 83.33 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2003Q2 | +DATA/ads_primary/datafile/test_rn_tg_ye2003q2.649.787919953 |
268 | 0 | 32.46 | 88.66 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2003Q3 | +DATA/ads_primary/datafile/test_rn_tg_ye2003q3.650.787919953 |
300 | 0 | 36.23 | 92.86 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2003Q4 | +DATA/ads_primary/datafile/test_rn_tg_ye2003q4.651.787919955 |
308 | 0 | 34.42 | 93.77 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2004Q1 | +DATA/ads_primary/datafile/test_rn_tg_ye2004q1.652.787919957 |
81 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2004Q2 | +DATA/ads_primary/datafile/test_rn_tg_ye2004q2.653.787919957 |
81 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2004Q3 | +DATA/ads_primary/datafile/test_rn_tg_ye2004q3.654.787919959 |
81 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2004Q4 | +DATA/ads_primary/datafile/test_rn_tg_ye2004q4.655.787919959 |
81 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2005Q1 | +DATA/ads_primary/datafile/test_rn_tg_ye2005q1.656.787919961 |
428 | 0 | 41.78 | 103.37 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2005Q2 | +DATA/ads_primary/datafile/test_rn_tg_ye2005q2.657.787919963 |
452 | 0 | 40.60 | 104.68 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2005Q3 | +DATA/ads_primary/datafile/test_rn_tg_ye2005q3.658.787919963 |
476 | 0 | 37.90 | 105.85 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2005Q4 | +DATA/ads_primary/datafile/test_rn_tg_ye2005q4.659.787919965 |
508 | 0 | 41.44 | 107.25 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2006Q1 | +DATA/ads_primary/datafile/test_rn_tg_ye2006q1.660.787919967 |
578 | 0 | 41.09 | 106.69 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2006Q2 | +DATA/ads_primary/datafile/test_rn_tg_ye2006q2.661.787919967 |
658 | 0 | 42.61 | 109.28 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2006Q3 | +DATA/ads_primary/datafile/test_rn_tg_ye2006q3.662.787919969 |
95 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2006Q4 | +DATA/ads_primary/datafile/test_rn_tg_ye2006q4.663.787919971 |
802 | 0 | 45.46 | 112.64 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2007Q1 | +DATA/ads_primary/datafile/test_rn_tg_ye2007q1.664.787919971 |
850 | 0 | 42.06 | 113.51 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2007Q2 | +DATA/ads_primary/datafile/test_rn_tg_ye2007q2.665.787919973 |
946 | 0 | 42.36 | 114.98 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2007Q3 | +DATA/ads_primary/datafile/test_rn_tg_ye2007q3.666.787919973 |
84 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2007Q4 | +DATA/ads_primary/datafile/test_rn_tg_ye2007q4.667.787919975 |
1,175 | 0 | 47.56 | 118.70 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2008Q1 | +DATA/ads_primary/datafile/test_rn_tg_ye2008q1.668.787919977 |
84 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2008Q2 | +DATA/ads_primary/datafile/test_rn_tg_ye2008q2.669.787919979 |
1,367 | 0 | 42.03 | 120.01 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2008Q3 | +DATA/ads_primary/datafile/test_rn_tg_ye2008q3.670.787919979 |
1,495 | 0 | 48.13 | 120.69 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2008Q4 | +DATA/ads_primary/datafile/test_rn_tg_ye2008q4.671.787919981 |
766 | 0 | 50.52 | 114.07 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2009Q1 | +DATA/ads_primary/datafile/test_rn_tg_ye2009q1.672.787919983 |
1,623 | 0 | 50.77 | 121.27 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2009Q2 | +DATA/ads_primary/datafile/test_rn_tg_ye2009q2.673.787919983 |
1,214 | 0 | 47.19 | 119.21 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2009Q3 | +DATA/ads_primary/datafile/test_rn_tg_ye2009q3.674.787919985 |
1,879 | 0 | 52.41 | 122.19 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2009Q4 | +DATA/ads_primary/datafile/test_rn_tg_ye2009q4.675.787919987 |
1,943 | 0 | 55.53 | 122.38 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2010Q1 | +DATA/ads_primary/datafile/test_rn_tg_ye2010q1.676.787919987 |
84 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2010Q2 | +DATA/ads_primary/datafile/test_rn_tg_ye2010q2.677.787919989 |
1,239 | 0 | 44.33 | 119.18 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2010Q3 | +DATA/ads_primary/datafile/test_rn_tg_ye2010q3.678.787919991 |
1,367 | 0 | 47.63 | 120.01 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2010Q4 | +DATA/ads_primary/datafile/test_rn_tg_ye2010q4.679.787919991 |
1,687 | 0 | 40.47 | 121.53 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2011Q2 | +DATA/ads_primary/datafile/test_rn_tg_ye2011q2.680.787919993 |
3,615 | 0 | 54.67 | 124.70 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2011Q3 | +DATA/ads_primary/datafile/test_rn_tg_ye2011q3.681.787919993 |
2,079 | 0 | 49.77 | 122.26 | 14 | 0 | 0 | 0.00 |
| TEST_RN_TG_YE2011Q4 | +DATA/ads_primary/datafile/test_rn_tg_ye2011q4.682.787919995 |
967 | 0 | 45.23 | 115.65 | 14 | 0 | 0 | 0.00 |
| TEST_TS_BI_INDEX | +DATA/ads_primary/datafile/test_ts_bi_index.683.787919997 |
13,992 | 1 | 50.89 | 127.07 | 14 | 0 | 0 | 0.00 |
| TS_ADB_INDEX | +DATA/ads/datafile/ts_adb_index.dbf |
1,945,396 | 135 | 0.23 | 1.69 | 4,392 | 0 | 275,530 | 1.15 |
| TS_ADB_INDEX | +DATA/ads/datafile/ts_adb_index.dbf01.dbf |
1,965,626 | 137 | 0.22 | 1.69 | 4,237 | 0 | 278,566 | 1.15 |
| TS_ADB_INDEX | +DATA/ads/datafile/ts_adb_index.dbf02.dbf |
1,972,497 | 137 | 0.21 | 1.68 | 4,136 | 0 | 276,674 | 1.11 |
| TS_ADB_INDEX | +DATA/ads/datafile/ts_adb_index.dbf03.dbf |
1,918,188 | 133 | 0.23 | 1.70 | 4,841 | 0 | 272,425 | 1.15 |
| TS_ADC_INDEX | +DATA/ads/datafile/ts_adc_index.dbf |
12,051 | 1 | 2.33 | 5.97 | 6,479 | 0 | 0 | 0.00 |
| TS_ADC_INDEX | +DATA/ads/datafile/ts_adc_index01.dbf |
11,116 | 1 | 2.51 | 6.36 | 6,518 | 0 | 8 | 0.00 |
| TS_ADC_INDEX | +DATA/ads/datafile/ts_adc_index02.dbf |
11,101 | 1 | 2.82 | 6.70 | 6,710 | 0 | 0 | 0.00 |
| TS_ADC_INDEX | +DATA/ads/datafile/ts_adc_index03.dbf |
11,541 | 1 | 2.78 | 6.34 | 6,616 | 0 | 2 | 0.00 |
| TS_ADF_INDEX | +DATA/ads/datafile/ts_adf_index.dbf |
3,501 | 0 | 50.96 | 110.79 | 168 | 0 | 0 | 0.00 |
| TS_ADF_INDEX | +DATA/ads/datafile/ts_adf_index01.dbf |
3,334 | 0 | 52.50 | 114.82 | 115 | 0 | 0 | 0.00 |
| TS_ADF_INDEX | +DATA/ads/datafile/ts_adf_index02.dbf |
3,434 | 0 | 53.55 | 117.30 | 80 | 0 | 0 | 0.00 |
| TS_ADF_INDEX | +DATA/ads/datafile/ts_adf_index03.dbf |
3,774 | 0 | 47.60 | 104.55 | 187 | 0 | 0 | 0.00 |
| TS_ADS | +DATA/ads/datafile/ts_ads.dbf |
40,045 | 3 | 20.87 | 62.78 | 18,832 | 1 | 1,249 | 3.70 |
| TS_ADS | +DATA/ads/datafile/ts_ads01.dbf |
36,562 | 3 | 18.99 | 65.50 | 11,653 | 1 | 2,747 | 2.27 |
| TS_ADS | +DATA/ads/datafile/ts_ads02.dbf |
28,651 | 2 | 16.41 | 57.88 | 14,289 | 1 | 1,180 | 4.52 |
| TS_ADS | +DATA/ads/datafile/ts_ads03.dbf |
36,304 | 3 | 21.83 | 66.65 | 13,958 | 1 | 1,432 | 3.99 |
| TS_ADS | +DATA/ads/datafile/ts_ads04.dbf |
28,945 | 2 | 15.54 | 55.81 | 15,129 | 1 | 1,091 | 4.42 |
| TS_ADS | +DATA/ads/datafile/ts_ads05.dbf |
36,841 | 3 | 20.50 | 65.40 | 17,083 | 1 | 1,048 | 3.89 |
| TS_ADS | +DATA/ads/datafile/ts_ads06.dbf |
43,258 | 3 | 18.22 | 60.68 | 17,693 | 1 | 1,360 | 3.18 |
| TS_ADS_TEMP | +DATA/ads/datafile/ts_ads_temp.dbf |
1,075 | 0 | 34.43 | 90.81 | 91 | 0 | 0 | 0.00 |
| TS_ADS_TEMP | +DATA/ads/datafile/ts_ads_temp01.dbf |
889 | 0 | 41.60 | 108.59 | 17 | 0 | 0 | 0.00 |
| TS_ADS_TEMP_INDEX | +DATA/ads/datafile/ts_ads_temp_index.dbf |
126 | 0 | 37.62 | 83.64 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TEMP_INDEX | +DATA/ads/datafile/ts_ads_temp_index01.dbf |
926 | 0 | 5.92 | 13.48 | 122 | 0 | 0 | 0.00 |
| TS_ADS_TEMP_INDEX | +DATA/ads/datafile/ts_ads_temp_index02.dbf |
138 | 0 | 34.28 | 75.54 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TEMP_INDEX | +DATA/ads/datafile/ts_ads_temp_index03.dbf |
137 | 0 | 35.26 | 76.08 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT00YUE | +DATA/ads_primary/datafile/ts_ads_tjxt00yue.599.763556309 |
2,500 | 0 | 59.02 | 122.66 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT00YUE_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt00yue_idx.577.763556327 |
1,028 | 0 | 53.15 | 116.76 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT01YUE | +DATA/ads_primary/datafile/ts_ads_tjxt01yue.598.763556309 |
7,151 | 0 | 51.65 | 124.44 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT01YUE_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt01yue_idx.576.763556329 |
3,149 | 0 | 55.40 | 124.33 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT02YUE | +DATA/ads_primary/datafile/ts_ads_tjxt02yue.597.763556311 |
7,376 | 1 | 53.37 | 124.54 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT02YUE_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt02yue_idx.575.763556329 |
868 | 0 | 54.35 | 114.68 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT03YUE | +DATA/ads_primary/datafile/ts_ads_tjxt03yue.596.763556311 |
7,788 | 1 | 51.25 | 124.72 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT03YUE_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt03yue_idx.574.763556329 |
3,380 | 0 | 63.15 | 124.51 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT04YUE | +DATA/ads_primary/datafile/ts_ads_tjxt04yue.595.763556313 |
8,010 | 1 | 49.68 | 124.47 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT04YUE_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt04yue_idx.573.763556331 |
3,465 | 0 | 60.08 | 124.59 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT05YUE | +DATA/ads_primary/datafile/ts_ads_tjxt05yue.594.763556313 |
8,214 | 1 | 51.92 | 124.63 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT05YUE_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt05yue_idx.572.763556331 |
3,595 | 0 | 63.71 | 124.71 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT06YUE | +DATA/ads_primary/datafile/ts_ads_tjxt06yue.593.763556313 |
5,987 | 0 | 45.06 | 105.61 | 235 | 0 | 0 | 0.00 |
| TS_ADS_TJXT06YUE_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt06yue_idx.571.763556333 |
690 | 0 | 0.00 | 1.00 | 240 | 0 | 0 | 0.00 |
| TS_ADS_TJXT07YUE | +DATA/ads_primary/datafile/ts_ads_tjxt07yue.592.763556315 |
5,986 | 0 | 51.43 | 123.83 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT07YUE_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt07yue_idx.570.763556333 |
2,571 | 0 | 55.61 | 123.41 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT08YUE | +DATA/ads_primary/datafile/ts_ads_tjxt08yue.591.763556315 |
6,215 | 0 | 53.93 | 124.14 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT08YUE_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt08yue_idx.569.763556335 |
2,645 | 0 | 63.27 | 124.06 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT09YUE | +DATA/ads_primary/datafile/ts_ads_tjxt09yue.590.763556317 |
6,362 | 0 | 55.04 | 124.14 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT09YUE_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt09yue_idx.568.763556335 |
2,690 | 0 | 57.96 | 124.13 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT10YUE | +DATA/ads_primary/datafile/ts_ads_tjxt10yue.589.763556317 |
6,572 | 0 | 53.77 | 124.43 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT10YUE_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt10yue_idx.567.763556335 |
2,809 | 0 | 62.94 | 124.29 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT11YUE | +DATA/ads_primary/datafile/ts_ads_tjxt11yue.588.763556319 |
6,768 | 0 | 50.91 | 124.26 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT11YUE_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt11yue_idx.566.763556337 |
2,157 | 0 | 56.72 | 123.29 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT12YUE | +DATA/ads_primary/datafile/ts_ads_tjxt12yue.587.763556319 |
7,096 | 0 | 52.83 | 124.70 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT12YUE_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt12yue_idx.565.763556337 |
2,966 | 0 | 57.77 | 124.49 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2008 | +DATA/ads_primary/datafile/ts_ads_tjxt2008.608.763556301 |
47,283 | 3 | 15.49 | 50.87 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2008_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt2008_idx.586.763556319 |
38,178 | 3 | 5.80 | 13.52 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2009 | +DATA/ads_primary/datafile/ts_ads_tjxt2009.607.763556301 |
17,978 | 1 | 15.11 | 48.46 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2009_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt2009_idx.585.763556321 |
16,062 | 1 | 5.85 | 13.98 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2010 | +DATA/ads_primary/datafile/ts_ads_tjxt2010.606.763556303 |
28,042 | 2 | 13.28 | 43.16 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2010_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt2010_idx.584.763556321 |
20,045 | 1 | 6.42 | 14.85 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2011 | +DATA/ads_primary/datafile/ts_ads_tjxt2011.605.763556303 |
41,926 | 3 | 13.59 | 41.00 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2011_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt2011_idx.583.763556323 |
21,186 | 1 | 8.06 | 18.70 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2012 | +DATA/ads_primary/datafile/ts_ads_tjxt2012.604.763556305 |
47,919 | 3 | 8.34 | 32.10 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2012_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt2012_idx.582.763556323 |
22,868 | 2 | 3.83 | 9.65 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2013 | +DATA/ads_primary/datafile/ts_ads_tjxt2013.603.763556305 |
90,540 | 6 | 7.99 | 26.35 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2013_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt2013_idx.581.763556323 |
22,518 | 2 | 9.77 | 22.97 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2014 | +DATA/ads_primary/datafile/ts_ads_tjxt2014.602.763556307 |
100,301 | 7 | 3.47 | 12.09 | 3,726 | 0 | 3,175 | 11.00 |
| TS_ADS_TJXT2014_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt2014_idx.580.763556325 |
22,628 | 2 | 0.00 | 1.27 | 7,267 | 1 | 41 | 19.51 |
| TS_ADS_TJXT2015 | +DATA/ads_primary/datafile/ts_ads_tjxt2015.601.763556307 |
89 | 0 | 1.91 | 5.27 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2015_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt2015_idx.579.763556325 |
94 | 0 | 0.00 | 1.00 | 14 | 0 | 1 | 10.00 |
| TS_ADS_TJXT2016 | +DATA/ads_primary/datafile/ts_ads_tjxt2016.600.763556307 |
90 | 0 | 2.00 | 5.22 | 14 | 0 | 0 | 0.00 |
| TS_ADS_TJXT2016_IDX | +DATA/ads_primary/datafile/ts_ads_tjxt2016_idx.578.763556327 |
94 | 0 | 0.00 | 1.00 | 14 | 0 | 2 | 5.00 |
| TS_ADS_YE2002 | +DATA/ads/datafile/ts_ads_ye2002.dbf |
1,073 | 0 | 50.84 | 125.28 | 14 | 0 | 0 | 0.00 |
| TS_ADS_YE2003_2007 | +DATA/ads/datafile/ts_ads_ye2003_2007.dbf |
8,031 | 1 | 51.51 | 123.79 | 14 | 0 | 0 | 0.00 |
| TS_ADS_YE2008 | +DATA/ads/datafile/ts_ads_ye2008.dbf |
4,493 | 0 | 61.04 | 122.90 | 14 | 0 | 0 | 0.00 |
| TS_ADS_YE2009 | +DATA/ads/datafile/ts_ads_ye2009.dbf |
5,737 | 0 | 59.23 | 125.71 | 14 | 0 | 0 | 0.00 |
| TS_ADS_YE2010 | +DATA/ads/datafile/ts_ads_ye2010.dbf |
4,709 | 0 | 57.84 | 125.94 | 14 | 0 | 0 | 0.00 |
| TS_ADS_YE2011 | +DATA/ads/datafile/ts_ads_ye2011.dbf |
6,525 | 0 | 52.79 | 126.36 | 14 | 0 | 0 | 0.00 |
| TS_ADS_YE2012 | +DATA/ads/datafile/ts_ads_ye2012.dbf |
6,578 | 0 | 58.59 | 125.96 | 14 | 0 | 0 | 0.00 |
| TS_ADS_YE2013 | +DATA/ads/datafile/ts_ads_ye2013.dbf |
23,304 | 2 | 16.71 | 124.89 | 14 | 0 | 0 | 0.00 |
| TS_ADS_YE2014 | +DATA/ads/datafile/ts_ads_ye2014.dbf |
63,604 | 4 | 2.59 | 27.65 | 935 | 0 | 1,313 | 2.44 |
| TS_ADS_YE2015 | +DATA/ads/datafile/ts_ads_ye2015.dbf |
25 | 0 | 6.00 | 11.12 | 14 | 0 | 0 | 0.00 |
| TS_ADS_YE2016 | +DATA/ads/datafile/ts_ads_ye2016.dbf |
25 | 0 | 4.80 | 11.12 | 14 | 0 | 0 | 0.00 |
| TS_BASE | +DATA/ads_primary/datafile/ts_base.433.763378699 |
454 | 0 | 29.38 | 67.86 | 19 | 0 | 0 | 0.00 |
| TS_BASE_INDEX | +DATA/ads_primary/datafile/ts_base_index.434.763378701 |
92 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_BI | +DATA/ads_primary/datafile/ts_bi.443.763378713 |
117 | 0 | 4.79 | 11.85 | 14 | 0 | 0 | 0.00 |
| TS_BI | +DATA/ads_primary/datafile/ts_bi.444.763378713 |
115 | 0 | 4.70 | 12.03 | 14 | 0 | 0 | 0.00 |
| TS_BI | +DATA/ads_primary/datafile/ts_bi.497.763382297 |
93 | 0 | 6.13 | 15.32 | 14 | 0 | 0 | 0.00 |
| TS_BI | +DATA/ads_primary/datafile/ts_bi.558.763382419 |
103 | 0 | 5.15 | 13.32 | 14 | 0 | 0 | 0.00 |
| TS_BI | +DATA/ads_primary/datafile/ts_bi.559.763382571 |
103 | 0 | 5.24 | 13.32 | 14 | 0 | 0 | 0.00 |
| TS_BI | +DATA/ads_primary/datafile/ts_bi.560.763382573 |
103 | 0 | 5.44 | 13.32 | 14 | 0 | 0 | 0.00 |
| TS_BI_INDEX | +DATA/ads_primary/datafile/ts_bi_index.445.763378715 |
16,520 | 1 | 44.86 | 127.08 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2006S | +DATA/ads_primary/datafile/ts_bzqx_value2006s.520.763382347 |
170 | 0 | 23.47 | 67.48 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2006X | +DATA/ads_primary/datafile/ts_bzqx_value2006x.521.763382349 |
79 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2007S | +DATA/ads_primary/datafile/ts_bzqx_value2007s.522.763382351 |
79 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2007X | +DATA/ads_primary/datafile/ts_bzqx_value2007x.523.763382353 |
210 | 0 | 29.95 | 83.85 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2008S | +DATA/ads_primary/datafile/ts_bzqx_value2008s.524.763382355 |
322 | 0 | 38.01 | 99.20 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2008X | +DATA/ads_primary/datafile/ts_bzqx_value2008x.525.763382357 |
426 | 0 | 39.51 | 106.23 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2009S | +DATA/ads_primary/datafile/ts_bzqx_value2009s.534.763382373 |
514 | 0 | 40.31 | 109.96 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2009X | +DATA/ads_primary/datafile/ts_bzqx_value2009x.535.763382375 |
538 | 0 | 42.79 | 110.77 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2010S | +DATA/ads_primary/datafile/ts_bzqx_value2010s.549.763382403 |
616 | 0 | 45.21 | 111.71 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2010X | +DATA/ads_primary/datafile/ts_bzqx_value2010x.550.763382405 |
664 | 0 | 50.62 | 112.89 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2011S | +DATA/ads_primary/datafile/ts_bzqx_value2011s.553.763382411 |
632 | 0 | 45.25 | 112.12 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2011X | +DATA/ads_primary/datafile/ts_bzqx_value2011x.554.763382413 |
664 | 0 | 40.44 | 112.89 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2012S | +DATA/ads_primary/datafile/ts_bzqx_value2012s.617.769966957 |
643 | 0 | 39.89 | 111.80 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2012X | +DATA/ads_primary/datafile/ts_bzqx_value2012x.630.787058157 |
78 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2013S | +DATA/ads_primary/datafile/ts_bzqx_value2013s.691.802950603 |
82 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2013X | +DATA/ads_primary/datafile/ts_bzqx_value2013x.692.802950605 |
541 | 0 | 40.33 | 108.28 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2014S | +DATA/ads_primary/datafile/ts_bzqx_value2014s.693.802950609 |
82 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_BZQX_VALUE2014X | +DATA/ads_primary/datafile/ts_bzqx_value2014x.694.802950611 |
86 | 0 | 1.74 | 3.20 | 14 | 0 | 0 | 0.00 |
| TS_CB | +DATA/ads_primary/datafile/ts_cb.536.763382377 |
74 | 0 | 1.22 | 2.70 | 14 | 0 | 0 | 0.00 |
| TS_CB_INDEX | +DATA/ads_primary/datafile/ts_cb_index.537.763382379 |
88 | 0 | 0.91 | 2.43 | 14 | 0 | 0 | 0.00 |
| TS_CB_TEMP | +DATA/ads_primary/tempfile/ts_cb_temp.493.763378781 |
4 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | |
| TS_CURVE_FORMULA2006S | +DATA/ads_primary/datafile/ts_curve_formula2006s.514.763382335 |
734 | 0 | 8.00 | 19.17 | 14 | 0 | 255 | 5.14 |
| TS_CURVE_FORMULA2006X | +DATA/ads_primary/datafile/ts_curve_formula2006x.515.763382337 |
931 | 0 | 7.80 | 19.69 | 15 | 0 | 735 | 4.56 |
| TS_CURVE_FORMULA2007S | +DATA/ads_primary/datafile/ts_curve_formula2007s.516.763382339 |
975 | 0 | 7.62 | 18.85 | 14 | 0 | 822 | 4.49 |
| TS_CURVE_FORMULA2007X | +DATA/ads_primary/datafile/ts_curve_formula2007x.517.763382341 |
1,152 | 0 | 8.64 | 20.54 | 14 | 0 | 1,187 | 4.48 |
| TS_CURVE_FORMULA2008S | +DATA/ads_primary/datafile/ts_curve_formula2008s.518.763382343 |
1,081 | 0 | 15.42 | 37.79 | 14 | 0 | 1,308 | 4.81 |
| TS_CURVE_FORMULA2008X | +DATA/ads_primary/datafile/ts_curve_formula2008x.519.763382345 |
806 | 0 | 0.00 | 1.02 | 14 | 0 | 1,446 | 4.72 |
| TS_CURVE_FORMULA2009S | +DATA/ads_primary/datafile/ts_curve_formula2009s.532.763382369 |
1,379 | 0 | 19.86 | 50.47 | 14 | 0 | 1,479 | 4.73 |
| TS_CURVE_FORMULA2009X | +DATA/ads_primary/datafile/ts_curve_formula2009x.533.763382371 |
1,502 | 0 | 23.62 | 49.12 | 14 | 0 | 1,441 | 4.71 |
| TS_CURVE_FORMULA2010S | +DATA/ads_primary/datafile/ts_curve_formula2010s.547.763382399 |
888 | 0 | 0.00 | 1.02 | 14 | 0 | 1,492 | 4.54 |
| TS_CURVE_FORMULA2010X | +DATA/ads_primary/datafile/ts_curve_formula2010x.548.763382401 |
1,691 | 0 | 19.33 | 49.00 | 14 | 0 | 1,558 | 4.35 |
| TS_CURVE_FORMULA2011S | +DATA/ads_primary/datafile/ts_curve_formula2011s.551.763382407 |
876 | 0 | 0.00 | 1.02 | 14 | 0 | 1,548 | 4.37 |
| TS_CURVE_FORMULA2011X | +DATA/ads_primary/datafile/ts_curve_formula2011x.552.763382409 |
998 | 0 | 0.00 | 1.02 | 14 | 0 | 1,617 | 4.51 |
| TS_CURVE_FORMULA2012S | +DATA/ads_primary/datafile/ts_curve_formula2012s.616.769966955 |
872 | 0 | 0.00 | 1.02 | 14 | 0 | 1,645 | 4.63 |
| TS_CURVE_FORMULA2012X | +DATA/ads_primary/datafile/ts_curve_formula2012x.629.787058157 |
1,704 | 0 | 23.98 | 60.71 | 14 | 0 | 1,731 | 5.25 |
| TS_CURVE_FORMULA2013S | +DATA/ads_primary/datafile/ts_curve_formula2013s.687.802950593 |
916 | 0 | 0.00 | 1.02 | 14 | 0 | 1,665 | 4.89 |
| TS_CURVE_FORMULA2013X | +DATA/ads_primary/datafile/ts_curve_formula2013x.688.802950595 |
1,013 | 0 | 0.00 | 1.02 | 14 | 0 | 1,808 | 5.15 |
| TS_CURVE_FORMULA2014S | +DATA/ads_primary/datafile/ts_curve_formula2014s.689.802950599 |
1,344 | 0 | 17.37 | 43.44 | 14 | 0 | 1,587 | 4.97 |
| TS_CURVE_FORMULA2014X | +DATA/ads_primary/datafile/ts_curve_formula2014x.690.802950601 |
86 | 0 | 1.51 | 3.20 | 14 | 0 | 0 | 0.00 |
| TS_DATAEXPORT | +DATA/ads_primary/datafile/ts_dataexport.439.763378709 |
91 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_DATAEXPORT_INDEX | +DATA/ads_primary/datafile/ts_dataexport_index.440.763378709 |
91 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_DATAGATE | +DATA/ads_primary/datafile/ts_datagate.528.763382361 |
32,867 | 2 | 33.58 | 127.44 | 538 | 0 | 0 | 0.00 |
| TS_DATAGATE | +DATA/ads_primary/datafile/ts_datagate.561.763392467 |
7,608 | 1 | 50.98 | 125.96 | 928 | 0 | 0 | 0.00 |
| TS_DATAGATE | +DATA/ads_primary/datafile/ts_datagate.562.763392471 |
7,484 | 1 | 52.62 | 125.90 | 16 | 0 | 0 | 0.00 |
| TS_DATAGATE_INDEX | +DATA/ads_primary/datafile/ts_datagate_index.529.763382363 |
74 | 0 | 1.62 | 2.70 | 14 | 0 | 0 | 0.00 |
| TS_ETL | +DATA/ads_primary/datafile/ts_etl.446.763378715 |
108 | 0 | 0.83 | 2.17 | 14 | 0 | 0 | 0.00 |
| TS_ETLTEST | +DATA/ads_primary/datafile/ts_etltest.556.763382417 |
77 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_ETL_INDEX | +DATA/ads_primary/datafile/ts_etl_index.447.763378717 |
92 | 0 | 1.20 | 2.37 | 14 | 0 | 0 | 0.00 |
| TS_FAS | +DATA/ads_primary/datafile/ts_fas.697.813176061 |
1,334 | 0 | 38.34 | 85.21 | 496 | 0 | 0 | 0.00 |
| TS_FAS_IDX | +DATA/ads_primary/datafile/ts_fas_idx.698.813176065 |
1,291 | 0 | 14.38 | 34.49 | 1,209 | 0 | 0 | 0.00 |
| TS_FAS_TEMP | +DATA/ads_primary/tempfile/ts_fas_temp.699.813176065 |
5 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | |
| TS_GTBJ | +DATA/ads_primary/datafile/ts_gtbj.510.763382327 |
6,344 | 0 | 6.80 | 27.10 | 103 | 0 | 0 | 0.00 |
| TS_GTBJ_INDEX | +DATA/ads_primary/datafile/ts_gtbj_index.511.763382329 |
1,616 | 0 | 19.97 | 60.65 | 123 | 0 | 1 | 10.00 |
| TS_HTIS | +DATA/ads_primary/datafile/ts_htis.563.763399015 |
34,652 | 2 | 11.35 | 29.37 | 45 | 0 | 15,794 | 10.86 |
| TS_HTIS_IDX | +DATA/ads_primary/datafile/ts_htis_idx.609.763399615 |
11,308 | 1 | 8.06 | 18.61 | 15 | 0 | 97 | 7.42 |
| TS_INDICS | +DATA/ads_primary/datafile/ts_indics.263.763378703 |
94 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_INDICS02 | +DATA/ads_primary/datafile/ts_indics02.526.763382359 |
70,910 | 5 | 6.62 | 15.41 | 733 | 0 | 11,424 | 1.81 |
| TS_INDICS02 | +DATA/ads_primary/datafile/ts_indics02.686.801239223 |
62,847 | 4 | 7.30 | 18.01 | 114 | 0 | 9,628 | 1.89 |
| TS_INDICS02_INDEX | +DATA/ads_primary/datafile/ts_indics02_index.527.763382359 |
42,786 | 3 | 21.39 | 93.20 | 14 | 0 | 15,989 | 11.21 |
| TS_INDICS02_TEMP | +DATA/ads_primary/tempfile/ts_indics02_temp.491.763378781 |
3 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | |
| TS_INDICS_INDEX | +DATA/ads_primary/datafile/ts_indics_index.436.763378705 |
156 | 0 | 18.33 | 51.06 | 14 | 0 | 0 | 0.00 |
| TS_MARKET | +DATA/ads_primary/datafile/ts_market.435.763378701 |
3,771 | 0 | 21.69 | 54.28 | 211 | 0 | 0 | 0.00 |
| TS_MARKET_INDEX | +DATA/ads_primary/datafile/ts_market_index.322.763378701 |
5,386 | 0 | 13.59 | 34.53 | 391 | 0 | 0 | 0.00 |
| TS_MARKET_TEMP | +DATA/ads_primary/tempfile/ts_market_temp.482.763378779 |
5 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | |
| TS_OGG | +DATA/ads_primary/datafile/ts_ogg.684.800718859 |
1,926 | 0 | 57.89 | 120.88 | 14 | 0 | 0 | 0.00 |
| TS_PAR_INDEX_SAMPLE_BOND_2006Y | +DATA/ads_primary/datafile/ts_par_index_sample_bond_2006y.618.776888563 |
419 | 0 | 44.15 | 103.14 | 14 | 0 | 0 | 0.00 |
| TS_PAR_INDEX_SAMPLE_BOND_2007Y | +DATA/ads_primary/datafile/ts_par_index_sample_bond_2007y.619.776888563 |
363 | 0 | 38.02 | 96.51 | 14 | 0 | 0 | 0.00 |
| TS_PAR_INDEX_SAMPLE_BOND_2008Y | +DATA/ads_primary/datafile/ts_par_index_sample_bond_2008y.620.776888565 |
419 | 0 | 40.21 | 100.72 | 14 | 0 | 0 | 0.00 |
| TS_PAR_INDEX_SAMPLE_BOND_2009Y | +DATA/ads_primary/datafile/ts_par_index_sample_bond_2009y.621.776888565 |
88 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_PAR_INDEX_SAMPLE_BOND_2010Y | +DATA/ads_primary/datafile/ts_par_index_sample_bond_2010y.622.776888567 |
691 | 0 | 46.73 | 111.46 | 14 | 0 | 0 | 0.00 |
| TS_PAR_INDEX_SAMPLE_BOND_2011Y | +DATA/ads_primary/datafile/ts_par_index_sample_bond_2011y.623.776888567 |
931 | 0 | 45.39 | 115.72 | 14 | 0 | 0 | 0.00 |
| TS_PAR_INDEX_SAMPLE_BOND_2012Y | +DATA/ads_primary/datafile/ts_par_index_sample_bond_2012y.624.776888569 |
1,499 | 0 | 45.56 | 120.37 | 14 | 0 | 0 | 0.00 |
| TS_PAR_INDEX_SAMPLE_BOND_2013Y | +DATA/ads_primary/datafile/ts_par_index_sample_bond_2013y.695.802950613 |
1,623 | 0 | 54.90 | 121.58 | 14 | 0 | 0 | 0.00 |
| TS_PAR_INDEX_SAMPLE_BOND_2014Y | +DATA/ads_primary/datafile/ts_par_index_sample_bond_2014y.696.802950615 |
763 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_PATROL | +DATA/ads_primary/datafile/ts_patrol.555.763382415 |
80 | 0 | 1.50 | 2.58 | 14 | 0 | 0 | 0.00 |
| TS_PERFSTAT | +DATA/ads_primary/datafile/ts_perfstat.530.763382365 |
71 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_REPORT | +DATA/ads_primary/datafile/ts_report.437.763378707 |
452 | 0 | 37.50 | 87.68 | 44 | 0 | 0 | 0.00 |
| TS_REPORT_INDEX | +DATA/ads_primary/datafile/ts_report_index.438.763378707 |
220 | 0 | 20.59 | 51.22 | 26 | 0 | 0 | 0.00 |
| TS_REPORT_TEMP | +DATA/ads_primary/tempfile/ts_report_temp.484.763378781 |
54 | 0 | 0.00 | 15.00 | 54 | 0 | 0 | |
| TS_REPTEST | +DATA/ads_primary/datafile/ts_reptest.557.763382417 |
91 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_RMAN | +DATA/ads_primary/datafile/ts_rman.531.763382367 |
71 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_SHUHAO | +DATA/ads_primary/datafile/ts_shuhao.625.782919043 |
82 | 0 | 1.83 | 4.09 | 14 | 0 | 0 | 0.00 |
| TS_SYSUSER | +DATA/ads_primary/datafile/ts_sysuser.441.763378711 |
285 | 0 | 0.00 | 1.05 | 368 | 0 | 0 | 0.00 |
| TS_SYSUSER_INDEX | +DATA/ads_primary/datafile/ts_sysuser_index.442.763378711 |
226 | 0 | 14.78 | 36.39 | 14 | 0 | 0 | 0.00 |
| TS_TEMP | +DATA/ads/datafile/ts_temp.dbf |
13,751 | 1 | 0.00 | 9.65 | 5,559 | 0 | 0 | |
| TS_TEMP | +DATA/ads/datafile/ts_temp01.dbf |
1,070 | 0 | 0.01 | 24.07 | 1,065 | 0 | 0 | |
| TS_TEMP | +DATA/ads/datafile/ts_temp02.dbf |
11,863 | 1 | 0.00 | 11.02 | 5,026 | 0 | 0 | |
| TS_TEMP | +DATA/ads/datafile/ts_temp03.dbf |
1,699 | 0 | 0.01 | 49.20 | 2,771 | 0 | 23 | 1.74 |
| TS_TJDB_HIS_SRC | +DATA/ads_primary/datafile/ts_tjdb_his_src.610.763489645 |
4,179 | 0 | 48.70 | 125.42 | 14 | 0 | 0 | 0.00 |
| TS_TJDB_HIS_SRC | +DATA/ads_primary/datafile/ts_tjdb_his_src.611.763489659 |
4,140 | 0 | 56.75 | 125.39 | 14 | 0 | 0 | 0.00 |
| TS_TJDB_HIS_SRC_IDX | +DATA/ads_primary/datafile/ts_tjdb_his_src_idx.613.763489701 |
83 | 0 | 1.08 | 2.52 | 14 | 0 | 0 | 0.00 |
| TS_TJJK | +DATA/ads_primary/datafile/ts_tjjk.700.835285197 |
538 | 0 | 15.39 | 42.46 | 155 | 0 | 0 | 0.00 |
| TS_TJJK_INDEX | +DATA/ads_primary/datafile/ts_tjjk_index.701.835285201 |
226 | 0 | 7.92 | 18.69 | 72 | 0 | 0 | 0.00 |
| TS_TJJK_TEMP | +DATA/ads_primary/tempfile/ts_tjjk_temp.702.835285201 |
4 | 0 | 0.00 | 1.00 | 0 | 0 | 0 | |
| TS_YE1998Y | +DATA/ads_primary/datafile/ts_ye1998y.448.763378717 |
90 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE1999Q1 | +DATA/ads_primary/datafile/ts_ye1999q1.449.763378717 |
91 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE1999Q2 | +DATA/ads_primary/datafile/ts_ye1999q2.450.763378719 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| TS_YE1999Q3 | +DATA/ads_primary/datafile/ts_ye1999q3.451.763378719 |
93 | 0 | 1.08 | 2.35 | 14 | 0 | 0 | 0.00 |
| TS_YE1999Q4 | +DATA/ads_primary/datafile/ts_ye1999q4.452.763378721 |
94 | 0 | 1.28 | 2.34 | 14 | 0 | 0 | 0.00 |
| TS_YE2000Q1 | +DATA/ads_primary/datafile/ts_ye2000q1.453.763378721 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| TS_YE2000Q2 | +DATA/ads_primary/datafile/ts_ye2000q2.454.763378721 |
94 | 0 | 0.74 | 2.34 | 14 | 0 | 0 | 0.00 |
| TS_YE2000Q3 | +DATA/ads_primary/datafile/ts_ye2000q3.455.763378723 |
91 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2000Q4 | +DATA/ads_primary/datafile/ts_ye2000q4.456.763378723 |
89 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2001Q1 | +DATA/ads_primary/datafile/ts_ye2001q1.457.763378725 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| TS_YE2001Q2 | +DATA/ads_primary/datafile/ts_ye2001q2.458.763378725 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| TS_YE2001Q3 | +DATA/ads_primary/datafile/ts_ye2001q3.459.763378725 |
94 | 0 | 1.17 | 2.34 | 14 | 0 | 0 | 0.00 |
| TS_YE2001Q4 | +DATA/ads_primary/datafile/ts_ye2001q4.460.763378727 |
94 | 0 | 0.96 | 2.34 | 14 | 0 | 0 | 0.00 |
| TS_YE2002Q1 | +DATA/ads_primary/datafile/ts_ye2002q1.461.763378727 |
78 | 0 | 0.64 | 2.62 | 14 | 0 | 0 | 0.00 |
| TS_YE2002Q2 | +DATA/ads_primary/datafile/ts_ye2002q2.462.763378729 |
75 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2002Q3 | +DATA/ads_primary/datafile/ts_ye2002q3.463.763378729 |
73 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2002Q4 | +DATA/ads_primary/datafile/ts_ye2002q4.464.763378729 |
77 | 0 | 1.17 | 2.64 | 14 | 0 | 0 | 0.00 |
| TS_YE2003Q1 | +DATA/ads_primary/datafile/ts_ye2003q1.465.763378731 |
78 | 0 | 1.03 | 2.62 | 14 | 0 | 0 | 0.00 |
| TS_YE2003Q2 | +DATA/ads_primary/datafile/ts_ye2003q2.466.763378731 |
78 | 0 | 1.41 | 2.62 | 14 | 0 | 0 | 0.00 |
| TS_YE2003Q3 | +DATA/ads_primary/datafile/ts_ye2003q3.467.763378733 |
68 | 0 | 1.32 | 2.85 | 14 | 0 | 0 | 0.00 |
| TS_YE2003Q4 | +DATA/ads_primary/datafile/ts_ye2003q4.468.763378733 |
69 | 0 | 1.16 | 2.83 | 14 | 0 | 0 | 0.00 |
| TS_YE2004Q1 | +DATA/ads_primary/datafile/ts_ye2004q1.469.763378735 |
66 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2004Q2 | +DATA/ads_primary/datafile/ts_ye2004q2.470.763378735 |
66 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2004Q3 | +DATA/ads_primary/datafile/ts_ye2004q3.471.763378735 |
69 | 0 | 1.16 | 2.83 | 14 | 0 | 0 | 0.00 |
| TS_YE2004Q4 | +DATA/ads_primary/datafile/ts_ye2004q4.472.763378737 |
67 | 0 | 1.19 | 2.88 | 14 | 0 | 0 | 0.00 |
| TS_YE2005Q1 | +DATA/ads_primary/datafile/ts_ye2005q1.473.763378737 |
69 | 0 | 1.74 | 2.83 | 14 | 0 | 0 | 0.00 |
| TS_YE2005Q2 | +DATA/ads_primary/datafile/ts_ye2005q2.474.763378739 |
69 | 0 | 1.45 | 2.83 | 14 | 0 | 0 | 0.00 |
| TS_YE2005Q3 | +DATA/ads_primary/datafile/ts_ye2005q3.475.763378739 |
69 | 0 | 0.87 | 2.83 | 14 | 0 | 0 | 0.00 |
| TS_YE2005Q4 | +DATA/ads_primary/datafile/ts_ye2005q4.476.763378739 |
66 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2006Q1 | +DATA/ads_primary/datafile/ts_ye2006q1.477.763378741 |
66 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2006Q2 | +DATA/ads_primary/datafile/ts_ye2006q2.478.763378741 |
69 | 0 | 1.30 | 2.83 | 14 | 0 | 0 | 0.00 |
| TS_YE2006Q3 | +DATA/ads_primary/datafile/ts_ye2006q3.479.763378743 |
67 | 0 | 1.34 | 2.88 | 14 | 0 | 0 | 0.00 |
| TS_YE2006Q4 | +DATA/ads_primary/datafile/ts_ye2006q4.480.763378743 |
68 | 0 | 1.76 | 2.85 | 14 | 0 | 0 | 0.00 |
| TS_YE2007Q1 | +DATA/ads_primary/datafile/ts_ye2007q1.498.763382299 |
83 | 0 | 1.08 | 2.52 | 14 | 0 | 0 | 0.00 |
| TS_YE2007Q2 | +DATA/ads_primary/datafile/ts_ye2007q2.499.763382301 |
80 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2007Q3 | +DATA/ads_primary/datafile/ts_ye2007q3.500.763382303 |
80 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2007Q4 | +DATA/ads_primary/datafile/ts_ye2007q4.501.763382305 |
83 | 0 | 1.08 | 2.52 | 14 | 0 | 0 | 0.00 |
| TS_YE2008Q1 | +DATA/ads_primary/datafile/ts_ye2008q1.502.763382309 |
83 | 0 | 0.96 | 2.52 | 14 | 0 | 0 | 0.00 |
| TS_YE2008Q2 | +DATA/ads_primary/datafile/ts_ye2008q2.503.763382311 |
74 | 0 | 1.35 | 2.70 | 14 | 0 | 0 | 0.00 |
| TS_YE2008Q3 | +DATA/ads_primary/datafile/ts_ye2008q3.504.763382313 |
74 | 0 | 1.35 | 2.70 | 14 | 0 | 0 | 0.00 |
| TS_YE2008Q4 | +DATA/ads_primary/datafile/ts_ye2008q4.505.763382315 |
74 | 0 | 1.35 | 2.70 | 14 | 0 | 0 | 0.00 |
| TS_YE2009Q1 | +DATA/ads_primary/datafile/ts_ye2009q1.506.763382317 |
71 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2009Q2 | +DATA/ads_primary/datafile/ts_ye2009q2.507.763382321 |
71 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2009Q3 | +DATA/ads_primary/datafile/ts_ye2009q3.508.763382323 |
74 | 0 | 1.22 | 2.70 | 14 | 0 | 0 | 0.00 |
| TS_YE2009Q4 | +DATA/ads_primary/datafile/ts_ye2009q4.509.763382325 |
74 | 0 | 1.22 | 2.70 | 14 | 0 | 0 | 0.00 |
| TS_YE2010Q1 | +DATA/ads_primary/datafile/ts_ye2010q1.539.763382385 |
88 | 0 | 1.02 | 2.43 | 14 | 0 | 0 | 0.00 |
| TS_YE2010Q2 | +DATA/ads_primary/datafile/ts_ye2010q2.540.763382387 |
88 | 0 | 1.14 | 2.43 | 14 | 0 | 0 | 0.00 |
| TS_YE2010Q3 | +DATA/ads_primary/datafile/ts_ye2010q3.541.763382389 |
85 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2010Q4 | +DATA/ads_primary/datafile/ts_ye2010q4.542.763382391 |
85 | 0 | 0.00 | 1.00 | 14 | 0 | 0 | 0.00 |
| TS_YE2011Q1 | +DATA/ads_primary/datafile/ts_ye2011q1.543.763382393 |
80 | 0 | 1.13 | 2.58 | 14 | 0 | 0 | 0.00 |
| TS_YE2011Q2 | +DATA/ads_primary/datafile/ts_ye2011q2.544.763382393 |
80 | 0 | 1.13 | 2.58 | 14 | 0 | 0 | 0.00 |
| TS_YE2011Q3 | +DATA/ads_primary/datafile/ts_ye2011q3.545.763382395 |
80 | 0 | 1.38 | 2.58 | 14 | 0 | 0 | 0.00 |
| TS_YE2011Q4 | +DATA/ads_primary/datafile/ts_ye2011q4.546.763382397 |
80 | 0 | 1.25 | 2.58 | 14 | 0 | 0 | 0.00 |
| TS_YWJC | +DATA/ads_primary/datafile/ts_ywjc.538.763382383 |
88 | 0 | 1.25 | 2.43 | 14 | 0 | 0 | 0.00 |
| TS_ZQDJ | +DATA/ads_primary/datafile/ts_zqdj.512.763382331 |
74 | 0 | 1.49 | 2.70 | 14 | 0 | 0 | 0.00 |
| TS_ZQDJ_INDEX | +DATA/ads_primary/datafile/ts_zqdj_index.513.763382333 |
74 | 0 | 1.22 | 2.70 | 14 | 0 | 0 | 0.00 |
| TS_ZW_YE_INDEX | +DATA/ads/datafile/ts_zw_ye_index.dbf |
59 | 0 | 1.19 | 3.14 | 14 | 0 | 0 | 0.00 |
| TS_ZW_YE_INDEX | +DATA/ads/datafile/ts_zw_ye_index01.dbf |
66 | 0 | 1.21 | 2.91 | 14 | 0 | 0 | 0.00 |
| UNDOTBS1 | +DATA/ads/datafile/undotbs1.258.752265643 |
1,155 | 0 | 31.71 | 72.80 | 110,354 | 8 | 32 | 0.00 |
| UNDOTBS2 | +DATA/ads_primary/datafile/undotbs2.734.848325443 |
87 | 0 | 2.53 | 6.09 | 0 | 0 | 0 | 0.00 |
| USERS | +DATA/ads/datafile/users.259.752265643 |
25 | 0 | 5.60 | 8.56 | 14 | 0 | 0 | 0.00 |