| SQL Id | SQL Text |
|---|
| 05v8jt1a9kqbj | select flowID, lx, cjrq, worker, title, usr_create, t_user.name from t_news, t_user where t_user.usr_id=usr_create and lx='XX' and isread='0' and WORKER='CG27' and rownum<=1 order by cjrq asc |
| 0699cx2uk9rwy | select flowID, lx, cjrq, worker, title, usr_create, t_user.name from t_news, t_user where t_user.usr_id=usr_create and lx='XX' and isread='0' and WORKER='AD06' and rownum<=1 order by cjrq asc |
| 0jxc58m28m259 | Select '0' As xz, t_kcsm_all.isbn, t_kcsm_all.sm, t_kcsm_all.dj, t_kcsm_all.Id, t_kcsm_all.ghdwh, (Select mc From t_ghdw Where bh=t_kcsm_all.ghdwh) As ghdwmc, (Select Sum(kccs) From t_kcsl Where Id=t_kcsm_all.id And kfbh=:as_kfbh And ywbmbh=:as_ywbmbh) As kccs, fun_getkykc_sl(t_kcsm_all.id, :as_ywbmbh) As kykc From t_kcsm_all Where t_kcsm_all.isbn Like :as_isbn And t_kcsm_all.sm Like :as_sm |
| 0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
| 0v3dvmc22qnam | insert into sys.col_usage$ (obj#, intcol#, equality_preds, equijoin_preds, nonequijoin_preds, range_preds, like_preds, null_preds, timestamp) values ( :objn, :coln, decode(bitand(:flag, 1), 0, 0, 1), decode(bitand(:flag, 2), 0, 0, 1), decode(bitand(:flag, 4), 0, 0, 1), decode(bitand(:flag, 8), 0, 0, 1), decode(bitand(:flag, 16), 0, 0, 1), decode(bitand(:flag, 32), 0, 0, 1), :time) |
| 0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') |
| 0yj9y9zr7uv7b |
INSERT INTO "T_XHD_XHQPHZ" "A1" ("FLOWID_HZ", "YWBMBH", "DH", "YXYBH", "YSDJH", "DJRQ", "REMARK", "LOCK_RQ", "LOCK_CZYBH", "YSPBJ", "SPCZYBH", "SPRQ", "CYBH", "FHYXJ", "TIHFS", "DHR", "DHWJM", "DJLX", "KFBH", "CHANGE") SELECT "A2"."FLOWID_HZ", "A2"."YWBMBH", "A2"."DH", "A2"."YXYBH", "A2"."YSDJH", "A2"."DJRQ", "A2"."REMARK", "A2"."LOCK_RQ", "A2"."LOCK_CZYBH", "A2"."YSPBJ", "A2"."SPCZYBH", "A2"."SPRQ", "A2"."CYBH", "A2"."FHYXJ", "A2"."TIHFS", "A2"."DHR",
"A2"."DHWJM", "A2"."DJLX", "A2"."KFBH", "A2"."CHANGE" FROM "T_XHD_XHQPHZ"@! "A2" WHERE "A2"."CHANGE"='8' AND NOT EXISTS (SELECT 1 FROM "T_XHD_XHQPHZ" "A3" WHERE "A3"."FLOWID_HZ"="A2"."FLOWID_HZ") |
| 167ygdj93nfws | SELECT COUNT(DISTINCT T_KCSM.ID), NVL(SUM(T_FHMX.SFCS), 0), SUM(T_FHMX.SFCS * T_KCSM.DJ), SUM(T_FHMX.SYS) FROM T_FHMX, T_KCSM WHERE T_FHMX.ID = T_KCSM.ID AND T_FHMX.DJLY<>'QC' AND T_FHMX.DBRQ>=DATE'2012-11-21' AND T_FHMX.DBRQ<DATE'2012-12-21'+1 AND trim(T_FHMX.YWBMBH) ='000001' |
| 1f4cn9wdnuh67 | INSERT INTO A_A(AAA) VALUES (:B1 ) |
| 1nxajz98btx7r |
SELECT '0' AS XZ, '0' AS ZP, "TMP_DHMX"."FLOWID_DHMX", "TMP_DHMX"."FLOWID_DJ", DECODE(TMP_DHMX.MFJCBJ, '1', '?', '') AS MFJCBJ, "TMP_DHMX"."ISBN", "TMP_DHMX"."SM", "TMP_DHMX"."DJ", "TMP_DHMX"."BB", "TMP_DHMX"."CBNY", NVL((SELECT TRIM(MC) FROM T_BB WHERE BH = "TMP_DHMX"."BB"), '?') AS BBMC, "TMP_DHMX"."LB", "TMP_DHMX"."LB" AS LBORI, NVL((SELECT TRIM(MC) FROM T_LB WHERE BH = "TMP_DHMX"."LB"), '?') AS LBMC, NVL((SELECT TRIM(MC) FROM T_LB WHERE BH = "TMP_DHMX"."LB"), '?') AS LBMCORI, "TMP_DHMX"."ZDQH", "TMP_DHMX"."ZDXH", "TMP_DHMX"."JHZK", "TMP_DHMX"."JHZK" AS JHZKORI, "TMP_DHMX"."SL" AS XXSL, "TMP_DHMX"."SL" A
S XXSL_OLD, "TMP_DHMX"."FHZK", "TMP_DHMX"."FHZK" AS FHZKORI, "TMP_DHMX"."DJSHSL", "TMP_DHMX"."YSSL", "TMP_DHMX"."TYBJ", "TMP_DHMX"."FL", "TMP_DHMX"."FL" AS FLORI, NVL((SELECT TRIM(MC) FROM T_FL WHERE BH = "TMP_DHMX"."FL"), '?') AS FLMC, NVL((SELECT TRIM(MC) FROM T_FL WHERE BH = "TMP_DHMX"."FL"), '?') AS FLMCORI, "TMP_DHMX"."FHFS", "TMP_DHMX"."FHFS" AS FHFSORI, NVL((SELECT TRIM(MC) FROM T_FHYXJ WHERE BH = "TMP_DHMX"."FHFS"), '?') AS FHFSMC, NVL((SELECT TRIM(MC) FROM T_FHYXJ WHERE BH = "TMP_DHMX"."FHFS"), '?') AS FHFSMCORI, "TMP_DHMX"."JZJTRQ", "TMP_DHMX"."JZJTRQ" AS JZJTRQORI, "TMP_DHMX"."XSZQ", "TMP_DHMX"."XSZQ" AS XSZQORI, "
TMP_DHMX"."SYLX", "TMP_DHMX"."REMARK" AS BZ, nvl("TMP_DHMX"."JHFS", '01') as jhfs, nvl("TMP_DHMX"."JHFS", '01') as jhfsori, nvl((select trim(mc) from t_sptz where bh=tmp_dhmx.sptz ), '?') as splxmc, nvl((select trim(mc) from t_sptz where bh=tmp_dhmx.sptz ), '?') as splxmcori, nvl("TMP_DHMX"."SPTZ", '01') as splx, nvl("TMP_DHMX"."SPTZ", '01') as splxori, (SELECT COUNT(DISTINCT ZDQH || ZDXH) FROM T_JCFYHG_DHMX WHERE T_JCFYHG_DHMX.FLOWID_TMP_DHMX = TMP_DHMX.FLOWID_DHMX) YJS, NVL((SELECT SUM(FYSHL - MZCS) FROM T_JCFYHG_DHMX WHERE T_JCFYHG_DHMX.FLOWID_TMP_DHMX = TMP_DHMX.FLOWID_DHMX), 0) MZQK, NVL((SELECT SUM(MZCS) FROM T_JCFYHG_DHMX WHERE T_JCFYHG_DHMX.FLOWID_TMP_DHMX = TMP_DHMX.FLOWID_DHMX), 0) FLSL, NVL((SELECT SUM(XSDS) FROM T_DPLS B WHERE B.FLOWID_DHMX = TMP_DHMX.FLOWID_DHMX AND EXISTS (SELECT 1 FROM T_JCFYHG_DHMX A WHERE A.ZDQH = B.ZDQH AND A.ZDXH = B.ZDXH AND
TMP_DHMX.FLOWID_DHMX = A.FLOWID_TMP_DHMX AND ROWNUM = 1) AND B.OKBJ = '0' AND B.XSDS - B.XDCS > 0), 0) WSPCS, NVL((SELECT SUM(XSDS) FROM T_DPLS B WHERE B.FLOWID_DHMX = TMP_DHMX.FLOWID_DHMX AND EXISTS (SELECT * FROM T_JCFYHG_DHMX A WHERE A.ZDQH = B.ZDQH AND A.ZDXH = B.ZDXH AND TMP_DHMX.FLOWID_DHMX = A.FLOWID_TMP_DHMX AND ROWNUM = 1) AND B.QSCLFS = '3' AND B.OKBJ = '1' AND B.XSDS - B.XDCS > 0), 0) BQBYCS, NVL((SELECT COUNT(*) FROM T_DM WHERE KFLX = 'YB' AND EXISTS (SELECT CYBH FROM TMP_DHDJ WHERE TMP_DHDJ.CYBH = T_DM.CYBH AND TMP_DHDJ.FLOWID_DJ = TMP_DHMX.FLOWID_DJ)), 0) YBS, NVL((SELECT SUM(XSDS) FROM T_DPLS WHERE CQ_FLAG = '1' AND FLOWID_DHMX = TMP_DHMX.FLOWID_DHMX), 0) CQCS, NVL((SELECT SUM(XSDS) FROM T_DPLS B WHERE B.FLOWID_DHMX = TMP_DHMX.FLOWID_DHMX) , 0) DPLSCS, NVL((SELECT SUM(yfsl) FROM T_YFSJ_TMP B WHERE B.FLOWID = TMP_DHMX.FLOWID_DHMX) , 0) YZPCS, nvl(trim(bblx), '0') as bblx, SM_BL FROM "TMP_DHMX" WHERE "TMP_DHMX"."FLOWID_DJ" =
:ls_flowid_dj |
| 1sf7z5yt25wvp | select flowID, lx, cjrq, worker, title, usr_create, t_user.name from t_news, t_user where t_user.usr_id=usr_create and lx='XX' and isread='0' and WORKER='AD03' and rownum<=1 order by cjrq asc |
| 1ssg89p1kwsq4 | SELECT COUNT(*), MIN(GHDWH) FROM TMP_DHDJ A WHERE A.SBBJ = '1' AND A.YWBMBH = :B1 AND EXISTS (SELECT 1 FROM T_GHDW_YWBM WHERE GHDWH=A.GHDWH AND YWBMBH=A.YWBMBH AND YWYBH=:B2 ) |
| 2578kan1n5sfs | SELECT NVL(MIN(SYS_VALUE), 0) FROM T_SYSSET WHERE SYS_ITEM = 'ZBPSTS' AND SYS_YWBMBH = :B1 |
| 263r04uvam19c | SELECT COUNT(*) FROM T_JCFYHG WHERE ISBN = :B7 AND SM = :B6 AND DJ = :B5 AND TRIM(GHDWH) = TRIM(:B4 ) AND YWBMBH = :B3 AND NVL(CZRQ0, SYSDATE)>= SYSDATE - :B2 AND HGPCH = DECODE(NVL(:B1 , '$'), '$', HGPCH, :B1 ) |
| 2hffz9ghnvn0y | SELECT * FROM T_DATA_SEND WHERE TB_DATA = '1' AND GET_OK_TB = '0' AND DATA_LX = 'YH' AND EXISTS (SELECT * FROM T_DM_TBDH WHERE DH = T_DATA_SEND.DH AND TB_STOP = '0') |
| 367va76haa4gv | Select Count(1), Count(1), 0, 0, 0 From ( SELECT COUNT(1), COUNT(DISTINCT T_KCSM.ID), 0, 0, 0 FROM T_HYJXC, T_KCSM, T_GHDW_YWBM WHERE T_KCSM.ID = T_HYJXC.ID AND T_GHDW_YWBM.GHDWH=T_HYJXC.HYBH AND T_GHDW_YWBM.YWBMBH=T_HYJXC.YWBMBH AND T_HYJXC.DBRQ>=DATE'2010-11-01' AND T_HYJXC.DBRQ<DATE'2012-12-21'+1 AND trim(T_HYJXC.YWBMBH)='000001' AND T_KCSM.SM LIKE '%???????%' GROUP BY T_HYJXC.HYBH, T_HYJXC.CYBH, T_KCSM.ID) |
| 38zzk15upx54k |
SELECT B.ID, DM1.DMJC AS DH, B.SM, TO_CHAR(B.DJ, '99999.99') AS DJ, T_GHDW.MC AS HYBH, T_BB.MC AS BB, B.SFCS, TO_CHAR(B.MY, '99999999.99') AS MY, B.FHZK, TO_CHAR(B.SY, '99999999.99') AS SY, TO_CHAR(B.DBRQ, 'YYYY-MM-DD') AS DBRQ, DM2.DMJC AS KFBH, B.PFPCH, B.CBNY, B.ISBN, T_FL.MC AS FL, TO_CHAR(B.PFRQ, 'YYYY-MM-DD') AS PFRQ, DM3.DMJC AS CYBH, B.BJLSH, T_DJLY.MC AS DJLX, B.CSPC, B.FHJHPC AS YH, ywbmbh as ywbmbh, b.tcmd FROM (SELECT A.*, rownum r FROM (SELECT T_FHMX.ywbmbh, T_FHMX.ID, T_FHMX.DH, T_KCSM.SM, T_KCSM.DJ, T_KCSM.GHDWH, T_KCSM.BB, T_FHMX.SFCS, T_FHMX.SFCS * T_KCSM.DJ AS MY, T_FHMX.FHZK, T_FHMX.SYS AS SY, T_FHMX.DBRQ, T_FHMX.KFBH, T_FHMX.PFPCH, T_KCSM.CBNY, T_KCSM.ISBN, T_KCSM.FL, T_FHMX.FHBMBH, T_FHMX.PFRQ, T_FHMX.BJLSH, T_FHMX.DJLY, T_FHMX.FHJHPC, T_FHMX.CSPC, (select dmjc from t_dm where dh=substr(t_fhmx.zzpc, 1, 6)) as tcmd FROM T_FHMX, T_KCSM, T_DM_YWBM WHERE T_KCSM.ID = T_FHMX.ID AND T_DM_YWBM.DH=T_FHMX.DH AND T_DM_YWBM.YWBMBH=T_FHMX.YWBMBH AND T_FHMX.DJLY
<>'QC' AND T_FHMX.DBRQ>=DATE'2012-11-21' AND T_FHMX.DBRQ<DATE'2012-12-21'+1 AND trim(T_FHMX.YWBMBH) ='000001' ORDER BY SM ASC) A WHERE rownum <= 50) B, T_BB, T_FL, T_GHDW, T_DM DM1, T_DM DM2, T_DM DM3, T_DJLY WHERE B.BB = T_BB.BH(+) AND B.FL = T_FL.BH(+) AND B.GHDWH = T_GHDW.BH(+) AND B.KFBH = DM2.DH AND B.DH = DM1.DH AND B.FHBMBH = DM3.DH AND B.DJLY = T_DJLY.BH AND r >= 1 |
| 3dv49mjp8hund | Select * From ( Select W.*, rownum As r From ( Select A.ID, B.ISBN, B.SM, DJ, (Select MC From T_BB Where BH=B.BB) As BB, A.KCCS, A.KCCS*B.DJ As MY, DECODE(B.SYLX, '0', ROUND(A.KCCS*B.PJZK*B.DJ/100, 2), A.KCCS*B.PJJJ) As SY, fun_getkykc_sl(A.ID, A.YWBMBH) AS KYKC, DECODE(B.SYLX, '0', B.PJZK, B.PJJJ) AS JHZJ, DECODE(B.SYLX, '0', B.FHZK, B.FHJG) AS FHZJ, (Select DM From T_DM Where DH=A.KFBH) As KFBH, (Select DM From T_DM Where DH=A.CYBH) As CYBH, (Select DM From T_DM Where DH=A.YWBMBH) As YWBMBH, (Select MC From T_FL Where BH=B.FL) As FL, '' AS HW, (Select MC From T_GHDW Where BH=B.GHDWH) As GHDWH, (Select Name From T_USER Where USR_ID=B.YWRYH) As YWRYH, B.TM, B.BC, B.CBNY, B.BIANZH, B.YIZH From T_KCSL_ALL A, T_KCSM_ALL B Where B.ID=A.ID(+) and b.ywbmbh=a.ywbmbh(+) AND TRIM(TRIM(B.YWBMBH))='000001' AND B.SM LIKE '%????%' ) W WHERE rownum <= 50 ) Where r >= 1 ORDER BY SM ASC |
| 3t4c92tu7a9qh | insert into t_graph (czybh, x_col, Y_COL1, Y_COL2, Y_COL3, Y_COL4, Y_COL5, Y_COL6) select 'CG19', gr.* from (SELECT MIN(T_DM1.DMJC) AS STAT_TYPE, COUNT(DISTINCT T_KCSM.ID) AS ID, SUM(T_FHMX.SFCS) AS CS, SUM(T_FHMX.SFCS * T_KCSM.DJ) AS MY, SUM(T_FHMX.SYS) AS SY, ABS(ROUND(SUM(T_FHMX.SFCS * T_KCSM.DJ) * 100 / 108935330.78, 2)) AS ZZMYBL, DECODE(SUM(T_FHMX.SFCS), 0, 0, ROUND(SUM(T_FHMX.SYS) * 100 / SUM(T_FHMX.SFCS * T_KCSM.DJ), 2)) AS PJJZ FROM T_FHMX, T_KCSM, t_dm , T_DM T_DM1 WHERE T_FHMX.ID = T_KCSM.ID AND t_dm.dh=t_fhmx.dh and T_FHMX.DJLY<>'QC' AND T_FHMX.YWBMBH = T_DM1.DH (+) AND T_FHMX.DBRQ>=DATE'2012-11-21' AND T_FHMX.DBRQ<DATE'2012-12-21'+1 AND trim(T_FHMX.YWBMBH) ='000001' GROUP BY T_DM1.DH ORDER BY MY desc) gr |
| 400qzhcvscakd |
SELECT round(bitand(s.ownerid, 65535)) parent_session_sid, round(bitand(s.ownerid, 16711680)/65536) parent_session_instid, s.INST_ID, rawtohex(SADDR) as saddr, s.SID, s.SERIAL#, s.AUDSID, rawtohex(PADDR) as paddr, s.USER#, s.USERNAME, s.COMMAND, s.OWNERID, s.TADDR, s.LOCKWAIT, s.STATUS, s.SERVER, s.SCHEMA#, s.SCHEMANAME, s.OSUSER, s.PROCESS, s.MACHINE, s.PORT, s.TERMINAL, UPPER(s.PROGRAM) PROGRAM, s.TYPE, s.SQL_ADDRESS, s.SQL_HASH_VALUE, s.SQL_ID, s.SQL_CHILD_NUMBER, s.SQL_EXEC_START, s.SQL_EXEC_ID, s.PREV_SQL_ADDR, s.PREV_HASH_VALUE, s.PREV_SQL_ID, s.PREV_CHILD_NUMBER, s.PREV_EXEC_START, s.PREV_EXEC_ID, s.PLSQL_ENTRY_OBJECT_ID, s.PLSQL_ENTRY_SUBPROGRAM_ID, s.PLSQL_OBJECT_ID, s.PLSQL_SUBPROGRAM_ID, s.MODULE, s.MODULE_HASH, s.ACTION, s.ACTION_HASH, s.CLIENT_INFO, s.FIXED_TABLE_SEQUENCE, s.ROW_WAIT_OBJ#, s.ROW_WAIT_FILE#, s.ROW_WAIT_BLOCK#, s.ROW_WAIT_ROW#, s.TOP_LEVEL_CALL#, s.LOGON_TIME, s.LAST_CALL_ET, s.PDML_ENABLED, s.FAILOVER_TY
PE, s.FAILOVER_METHOD, s.FAILED_OVER, s.RESOURCE_CONSUMER_GROUP, s.PDML_STATUS, s.PDDL_STATUS, s.PQ_STATUS, s.CURRENT_QUEUE_DURATION, s.CLIENT_IDENTIFIER, s.BLOCKING_SESSION_STATUS, s.BLOCKING_INSTANCE, s.BLOCKING_SESSION, s.FINAL_BLOCKING_SESSION_STATUS, s.FINAL_BLOCKING_INSTANCE, s.FINAL_BLOCKING_SESSION, s.SEQ#, s.EVENT#, s.EVENT, s.P1TEXT, s.P1, s.P1RAW, s.P2TEXT, s.P2, s.P2RAW, s.P3TEXT, s.P3, s.P3RAW, s.WAIT_CLASS_ID, s.WAIT_CLASS#, s.WAIT_CLASS, s.WAIT_TIME, s.SECONDS_IN_WAIT, s.STATE, s.WAIT_TIME_MICRO, s.TIME_REMAINING_MICRO, s.TIME_SINCE_LAST_WAIT_MICRO, s.SERVICE_NAME, s.SQL_TRACE, s.SQL_TRACE_WAITS, s.SQL_TRACE_BINDS, s.SQL_TRACE_PLAN_STATS, s.SESSION_EDITION_ID, s.CREATOR_ADDR, s.CREATOR_SERIAL#, s.ECID FROM GV$SESSION S WHERE ( (s.USERNAME is not null) and (NVL(s.osuser, 'x') <> 'SYSTEM') and (s.type <> 'BACKGROUND') ) order by "USERNAME", OWNERID |
| 459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
| 4b4mzq5z4zrp0 | Select '0' as xz, a.isbn, a.sm, a.dj, a.Kcmin, a.Kcmax, a.Ghdwh, (Select mc From t_ghdw Where bh=a.ghdwh) As ghdwmc, (Select mc From t_bb Where bh=a.bb) As bbmc, (Select mc From t_fl Where bh=a.fl) As flmc, a.Bianzh, a.yizh, a.bc, a.cbny, a.Lastdhrq, a.id, nvl((select kccs from t_kcsl where id=a.id and ywbmbh=a.ywbmbh and kfbh='2001'), 0)as kccs, nvl((select sum(T_LSDJXC_ID.JHCS - T_LSDJXC_ID.JTCS - T_LSDJXC_ID.LSCS + T_LSDJXC_ID.SYCS - T_LSDJXC_ID.BFCS) from T_LSDJXC_ID where id = a.id and ywbmbh=a.ywbmbh), 0) as mdkc , nvl((select sum(T_LSDJXC_ID.LSCS) from T_LSDJXC_ID where id = a.id and ywbmbh=a.ywbmbh), 0) as xscs From t_kcsm_all a Where a.zdsflag='1' and a.ywryh =:as_ywybh and a.ywbmbh=:as_ywbmbh |
| 4n14q9c51yfbd |
select ysdjh as ysddlsh, djrq, djly, dh, dm, (select mc from t_bb where bh=a.bb) as bbmc, isbn, sm, dj, xsds, xdcs, wcxdcs, phcs, zt, reason, zdqh, zdxh, pfpch, fyjhpc, fyrq, ywbmbh, cybh, id, ddfk_remark, ddfk_type, ddfk_date from (Select T_DPLS.TDPCH As ysdjh, (Select ddfk_remark From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_remark, (Select ddfk_type From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_type, (Select ddfk_date From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_date, decode(nvl(t_dpls.ysddlsh, 0), 0, t_dpls.czrq, (Select djrq From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh)) djrq, t_dpls.zdqh, t_dpls.zdxh, decode(t_dpls.qsclfs, '0', '????', '1', '????', '3', '????') As qsclfs, decode(t_dpls.spbj, '1', '????', '') As fhyq, t_dpls.dh, (Select dm From t_dm Where dh = t_dpls.dh) As dm, (Select nvl(lsdbj, '0') From t_dm_ywbm Where dh = t_dpls.dh And ywbmbh = t_dpls.ywbmbh) As lsdbj, T_jczdml.isbn As isbn, t_jczdml.sm A
s sm, t_jczdml.dj As dj, t_jczdml.bb As bb, t_dpls.xsds, decode(t_dpls.ywshbj, '1', t_dpls.xdcs, 0) As xdcs, t_dpls.wcxdcs, t_dpls.phcs, Case When /*t_dpls.XDCS = 0 AND*/ YWSHBJ <> '1' Then '???' When t_dpls.XDCS = 0 And YWSHBJ = '1' Then '???' When t_dpls.phcs > 0 And (Select Count(1) From t_fhmx, t_fhhz Where t_fhhz.pfpch = t_fhmx.pfpch And t_fhmx.zdh = t_dpls.dbdh) > 1 Then '???' When t_dpls.XDCS > 0 And t_dpls.xdcs = t_dpls.wcxdcs And t_dpls.PHCS = 0 Then '???' When t_dpls.phcs > 0 Then '???' When t_dpls.XDCS > 0 Then '???' End As ZT, decode(t_dpls.djly, 'TD', '??', 'XP', '??', 'YB', '??', 'XQ', '??', 'QH', '??', 'QQ', '??', 'QS', '??', 'QP', '??', 'LT', '??', 'ZF', '??') As djly, t_dpls.CZRQ, Case When ((t_dpls.XDCS = 0 And t_dpls.YWSHBJ = '1') Or t_dpls.YWSHBJ <> '1') Then (Case When t_dpls.okbj <> '1' Then '????-' || fun_get_ddsp_cg_czy(t_dpls.fshpch) When t_dpls.ywshbj <> '1' Then '????-' || nvl(fun_get_dd
sp_yx_czy(t_dpls.dbdh), fun_get_name(t_dpls.usr_id)) When t_dpls.cq_flag = '1' Then '????' When t_dpls.cq_flag = '2' Then '????' When fun_getpmsjkc(t_dpls.id, t_dpls.ywbmbh, t_dpls.cybh) > 0 Then '????' When fun_getkykc(t_dpls.id, t_dpls.ywbmbh, t_dpls.cybh) < t_dpls.xsds Then '????' When fun_frozen_chk(t_dpls.dh, t_dpls.ywbmbh) = '1' Then '????' When t_dpls.qsclfs = '3' Then '????' End) End reason, t_dpls.ywbmbh, t_dpls.cybh, t_dpls.id, '' As pfpch, '' As fyjhpc, Null As fyrq, Null As flowid_dhmx From T_DPLS, T_jczdml Where T_DPLS.zdqh = T_jczdml.zdqh And T_DPLS.zdxh = T_jczdml.zdxh And nvl(T_DPLS.DJLY, 'AA') In ('TD', 'XP', 'YB', 'XQ', 'QH', 'QQ', 'QS', 'QP', 'LT', 'ZF') And t_dpls.id Is Null And FSHPCH Is Not Null AND SM LIKE '%COBS????????????5DVD 2CD%' AND (T_DPLS.ID IS NOT NULL OR T_DPLS.FLOWID_DHMX IS NOT NULL) AND TRIM(T_DPLS.YWBMBH)= '000001' Union All Select T_DPLS.TDPCH As ysdjh, (Select ddfk_remark From t_xhd_xhqpmx Where flowid_mx = t_dpls.ys
ddlsh) ddfk_remark, (Select ddfk_type From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_type, (Select ddfk_date From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_date, decode(t_dpls.ysddlsh, 0, t_dpls.czrq, (Select djrq From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh)) As djrq, t_dpls.zdqh, t_dpls.zdxh, decode(t_dpls.qsclfs, '0', '????', '1', '????', '3', '????') As qsclfs, decode(t_dpls.spbj, '1', '????', '') As fhyq, t_dpls.dh, (Select dm From t_dm Where dh = t_dpls.dh) As dm, (Select nvl(lsdbj, '0') From t_dm_ywbm Where dh = t_dpls.dh And ywbmbh = t_dpls.ywbmbh) As lsdbj, t_kcsm.isbn As isbn, t_kcsm.sm As sm, t_kcsm.dj As dj, t_kcsm.bb As bb, t_dpls.xsds, t_dpls.xdcs, t_dpls.wcxdcs, t_dpls.phcs, Case When /*t_dpls.XDCS = 0 AND*/ YWSHBJ <> '1' Then '???' When t_dpls.XDCS = 0 And YWSHBJ = '1' And cq_flag = '2' Then '???' When t_dpls.XDCS = 0 And YWSHBJ = '1' And cq_flag <> '2' Then '???' When t_dpls.phcs > 0 And (Select C
ount(1) From t_fhmx, t_fhhz Where t_fhhz.pfpch = t_fhmx.pfpch And t_fhmx.zdh = t_dpls.dbdh) > 1 Then '???' When t_dpls.XDCS > 0 And t_dpls.xdcs = t_dpls.wcxdcs And t_dpls.PHCS = 0 Then '???' When t_dpls.phcs > 0 Then '???' When t_dpls.XDCS > 0 Then '???' End As ZT, decode(t_dpls.djly, 'TD', '??', 'XP', '??', 'YB', '??', 'XQ', '??', 'QH', '??', 'QQ', '??', 'QS', '??', 'QP', '??', 'LT', '??', 'ZF', '??') As djly, t_dpls.CZRQ, Case When ((t_dpls.XDCS = 0 And t_dpls.YWSHBJ = '1') Or t_dpls.YWSHBJ <> '1') Then (Case When t_dpls.okbj <> '1' Then '????-' || fun_get_ddsp_cg_czy(t_dpls.fshpch) When t_dpls.ywshbj <> '1' Then '????-' || nvl(fun_get_ddsp_yx_czy(t_dpls.dbdh), fun_get_name(t_dpls.usr_id)) When t_dpls.cq_flag = '1' Then '????' When t_dpls.cq_flag = '2' Then '????' When fun_getpmsjkc(t_dpls.id, t_dpls.ywbmbh, t_dpls.cybh) > 0 Then '????' When fun_getkykc(t_dpls.id, t_dpls.ywbmbh, t_dpls.cybh) < t_dpls.xsds Then '????' Wh
en fun_frozen_chk(t_dpls.dh, t_dpls.ywbmbh) = '1' Then '????' When t_dpls.qsclfs = '3' Then '????' End) End reason, t_dpls.ywbmbh, t_dpls.cybh, t_dpls.id, (Select Min(pfpch) From t_fhmx Where zdh = t_dpls.dbdh) As pfpch, (Select Min(fhjhpc) From t_fhmx Where zdh = t_dpls.dbdh) As fyjhpc, (Select Min(fyrq) From t_fhmx Where zdh = t_dpls.dbdh) As fyrq, t_dpls.flowid_dhmx As flowid_dhmx From T_DPLS, T_kcsm Where T_DPLS.id = T_kcsm.id And FSHPCH Is Not Null And nvl(T_DPLS.DJLY, 'AA') In ('TD', 'XP', 'YB', 'XQ', 'QH', 'QQ', 'QS', 'QP', 'LT', 'ZF') AND SM LIKE '%COBS????????????5DVD 2CD%' AND (T_DPLS.ID IS NOT NULL OR T_DPLS.FLOWID_DHMX IS NOT NULL) AND TRIM(T_DPLS.YWBMBH)= '000001'Union All Select T_JCDD.YSDJH As ysdjh, '' ddfk_remark, '' ddfk_type, null ddfk_date, decode(t_jcdd.ysddlsh, 0, t_jcdd.czrq0, (Select djrq From t_xhd_xhqpmx Where flowid_mx = t_jcdd.ysddlsh)) As djrq, t_jcdd.zdqh, t_jcdd.zdxh, decode(t_jcdd.qsclfs, '0', '????', '1', '????', '3',
'????', '4', '????', '5', '????', '7', '????') As qsclfs, decode(t_jcdd.qsclfs, '4', '????', '5', '????', '7', '????', '') As fhyq, t_jcdd.dh, (Select dm From t_dm Where dh = t_jcdd.dh) As dm, (Select nvl(lsdbj, '0') From t_dm_ywbm Where dh = t_jcdd.dh And ywbmbh = t_jcdd.ywbmbh) As lsdbj, T_jczdml.isbn As isbn, t_jczdml.sm As sm, t_jczdml.dj As dj, t_jczdml.bb As bb, t_jcdd.xsds, 0, 0, 0, '???' As zt, decode(t_jcdd.djly, 'TD', '??', 'XP', '??', 'YB', '??', 'XQ', '??', 'QH', '??', 'QQ', '??', 'QS', '??', 'QP', '??', 'LT', '??', 'ZF', '??') As djly, t_jcdd.CZRQ0, '' As reason, t_jcdd.ywbmbh, t_jcdd.fhdh, t_jcdd.id, '' As pfpch, '' As fyjhpc, Null As fyrq, Null As flowid_dhmx From T_jcdd, t_jczdml Where T_jcdd.zdqh = t_jczdml.zdqh And t_jcdd.zdxh = T_jczdml.zdxh AND SM LIKE '%COBS????????????5DVD 2CD%' AND TRIM(T_JCDD.YWBMBH)= '000001') a |
| 4nqwsjpcss75t |
SELECT TT.ID, TT.ISBN, TT.SM, TT.DJ, FUN_GET_BB(TT.BB) BB, TT.BB as BBBH, (select t_fl.mc from t_fl where t_fl.bh=tt.fl) flmc, tt.fl, tt.bc, tt.yc, tt.cbny, (select t_kaiben.mc from t_kaiben where t_kaiben.bh=tt.kb) kbmc, tt.kb, (select t_zhzh.mc from t_zhzh where t_zhzh.bh=tt.zz) zzmc, tt.zz, tt.bianzh, tt.yizh, (select t_nj.mc from t_nj where t_nj.bh=tt.nj) njmc, tt.nj, (select t_nz.mc from t_nz where t_nz.bh=tt.nz) nzmc, tt.nz, (select t_xz.mc from t_xz where t_xz.bh=tt.xz) xzmc, tt.xz, tt.zfk, (select t_wz.mc from t_wz where t_wz.bh=tt.wz) wzmc, tt.wz, tt.mfjcbj, (select t_splx.mc from t_splx where t_splx.bh=tt.splx) splxmc, tt.splx, (select t_sptz.mc from t_sptz where t_sptz.bh=tt.sptz) sptzmc, tt.sptz, (select t_zt.mc from t_zt where t_zt.bh=tt.zt) ztmc, tt.zt, tt.sl, tt.sm_cs, tt.sm_bl, tt.sm_fcs, (select t_kbbb.mc from t_kbbb where t_kbbb.bh=tt.ysxlh) kbbbmc, tt.ysxlh, tt.gddzdjbz, tt.gdzkbj, tt.pxdz, tt.Pxdj, tt.Fhzk, tt.Xszq, tt.Xtl,
tt.Jzxtrq, tt.Jtjzrq, tt.Bfbj, tt.cip, tt.sylx, tt.fhjg, tt.tsbj as tsbjbh, (select t_tssmbj.mc from t_tssmbj where t_tssmbj.bh=tt.TSBJ) tsbjmc FROM ( SELECT ROWNUM RN, T_KCSM_YWBM.ID, T1.ISBN, T1.SM, T1.DJ, T1.BB, T1.Fl, T1.bc, T1.yc, T1.Cbny, T1.Kb, T1.zz, t1.bianzh, t1.yizh, t1.nj, t1.nz, t1.xz, t1.zfk, t1.wz, t1.mfjcbj, t1.splx, t1.sptz, t1.zt, t1.sl, t1.sm_cs, t1.sm_bl, t1.sm_fcs, t1.ysxlh, t1.tsbj, T_KCSM_YWBM.gddzdjbz, T_KCSM_YWBM.gdzkbj, T_KCSM_YWBM.pxdz, T_KCSM_YWBM.Pxdj, T_KCSM_YWBM.Fhzk, T_KCSM_YWBM.Xszq, T_KCSM_YWBM.Xtl, T_KCSM_YWBM.Jzxtrq, T_KCSM_YWBM.Jtjzrq, T_KCSM_YWBM.Bfbj, t1.cip, t_kcsm_ywbm.sylx, t_kcsm_ywbm.fhjg FROM T_KCSM_YWBM , T_KCSM T1 WHERE T1.ID = T_KCSM_YWBM.ID AND T_KCSM_YWBM.YWBMBH =:YWBMBH And t1.sm like :sm AND ROWNUM<=:maxrow ) TT WHERE TT.RN >:minrow |
| 5a67s33729x0h | begin PKG_COLLECTION_QUERYSTAT.PROC_COLLECTION_QUERY(V_BUSINESS_TYPE=>:V_BUSINESS_TYPE, v_sql=>:v_sql, v_rowperpage=>:v_rowperpage, v_page=>:v_page, v_orderColumn=>:v_orderColumn, v_orderStyle=>:v_orderStyle, v_czybh=>:v_czybh, v_totalRecords=>:v_totalRecords, v_totalPages=>:v_totalPages, v_pz=>:v_pz, v_cs=>:v_cs, v_my=>:v_my, v_sy=>:v_sy, v_ml=>:v_ml, v_mlv=>:v_mlv, cur_OUT=>:cur_OUT, ERRNO=>:ERRNO, ERRTEXT=>:ERRTEXT); end; |
| 5rygsj4dbw6jt | insert into sys.mon_mods$ (obj#, inserts, updates, deletes, timestamp, flags, drop_segments) values (:1, :2, :3, :4, :5, :6, :7) |
| 5s34t44u10q4g | SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1 |
| 5s4rt4d4xwbm1 | UPDATE C_DJH SET F_LSH = TO_CHAR(TO_NUMBER(F_LSH) + 1) WHERE F_BMBH = :B3 AND UPPER(F_DJMC) = UPPER(:B2 ) AND F_YEAR = :B1 |
| 5ur69atw3vfhj | select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1 |
| 5zacwau31dwyr | SELECT NVL(SUM(JHCS - JTCS - LSCS + SYCS), 0) FROM T_LSDJXC_ID_LS WHERE ID = :B2 AND TRIM(YWBMBH) = TRIM(:B1 ) |
| 60a6xjtmbav93 | select flowID, lx, cjrq, worker, title, usr_create, t_user.name from t_news, t_user where t_user.usr_id=usr_create and lx='XX' and isread='0' and WORKER='CG25' and rownum<=1 order by cjrq asc |
| 63qj2yk3rb3s1 | Select Count(*), Count(Distinct a.id), Sum(a.kccs), Sum(a.kccs*b.dj), Sum(decode(b.sylx, '0', round(a.kccs*b.dj*b.pjzk/100, 2), a.kccs*b.pjjj)) From T_KCSL_ALL A, t_kcsm_all B Where b.id=a.id(+) And b.ywbmbh=a.ywbmbh(+) AND TRIM(TRIM(B.YWBMBH))='000001' AND B.SM LIKE '%??????????????6DVD %' |
| 69k5bhm12sz98 |
SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE
_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst |
| 6khp15waxu0s1 | Select Count(*), Count(Distinct a.id), Sum(a.kccs), Sum(a.kccs*b.dj), Sum(decode(b.sylx, '0', round(a.kccs*b.dj*b.pjzk/100, 2), a.kccs*b.pjjj)) From T_KCSL_ALL A, t_kcsm_all B Where b.id=a.id(+) And b.ywbmbh=a.ywbmbh(+) AND TRIM(TRIM(B.YWBMBH))='000001' AND B.SM LIKE '%???%' |
| 6p5wa4pnw140a | SELECT :B5 || F_YEAR || LPAD(TRIM(F_LSH), DECODE(LENGTH(TRIM(:B4 )), 2, 7, 8), '0') || TRIM(:B4 ) FROM C_DJH WHERE F_BMBH = :B3 AND F_DJMC = UPPER(:B2 ) AND F_YEAR = :B1 |
| 6pc5a9r5zty42 | INSERT INTO T_SL_YFSJ (FLOWID, FLOWID_DJ, DH, ID, YFSL, SYLX, QSCLFS, RECEFLAG, FLAG, YFBJ, OKSL, YXJ, TPH, FLOWID_YFSJ, XSZQ, SDHRQ, ZJXS, FHZK, YSDJH, DJLY, WCXDCS, PHCS, YFSL_BAK, CYBH, CGYJ_KH, FLOWID_YFSJ1) SELECT A.FLOWID, A.FLOWID_DJ, A.DH, A.ID, A.YFSL, A.SYLX, A.QSCLFS, A.RECEFLAG, A.FLAG, A.YFBJ, A.OKSL, TRIM((SELECT NVL(FHFS, 'D') FROM TMP_DHMX WHERE FLOWID_DHMX = A.FLOWID)), A.TPH, A.FLOWID_YFSJ, A.XSZQ, A.SDHRQ, A.ZJXS, A.FHZK, '-'||TRIM(A.YSDJH), A.DJLY, A.WCXDCS, A.PHCS, A.YFSL, A.CYBH, A.CGYJ_KH, 0 FROM T_YFSJ_TMP A, T_DM_YWBM B WHERE A.DH = B.DH AND B.YWBMBH = :B2 AND (NVL(B.LSDBJ, '0') = '1' ) AND A.FLOWID_DJ = :B1 AND A.DJLY = 'XP' AND A.YFSL > 0 AND EXISTS (SELECT 1 FROM TMP_DHMX WHERE FLOWID_DHMX=A.FLOWID AND SPTZ='01') |
| 6wm3n4d7bnddg |
SELECT source, (case when time_secs < 1 then 1 else time_secs end) as time_secs, operation FROM ( SELECT 1 as source, trunc((sysdate - cast(ll.log_date as date)) * 86400) as time_secs, decode(ll.operation, 'OPEN', 0 , 1 ) as operation, ll.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG ll , ( SELECT max(l.log_id) as max_log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGROUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) < ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) ) max_log WHERE ll.log_id = max_log.max_log_id UNION ALL SELECT 2 as source, trunc((sysdate - cast(l.log_date as date)) * 86400) as time_secs, decode(l.operation, 'OPEN', 0 , 1 ) as operation, l.log_id as log_id FROM DBA_SCHEDULER_WINDOW_LOG l , DBA_SCHEDULER_WINGR
OUP_MEMBERS m WHERE l.window_name = m.window_name AND m.window_group_name = 'MAINTENANCE_WINDOW_GROUP' AND l.operation in ('OPEN', 'CLOSE') AND CAST(l.log_date AS DATE) <= ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) AND CAST(l.log_date AS DATE) >= ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WHERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) UNION ALL SELECT 0 as source, trunc((sysdate - et.etime) * 86400) as time_secs, 3 as operation, 0 as log_id FROM ( SELECT cast(max(end_interval_time) as date) as etime FROM WRM$_SNAPSHOT esi WHERE esi.dbid = :dbid AND esi.instance_number = :inst AND esi.snap_id = :eid ) et UNION ALL SELECT 0 as source, trunc((sysdate - bt.btime) * 86400) as time_secs, 2 as operation, 0 as log_id FROM ( SELECT cast(min(end_interval_time) as date) as btime FROM WRM$_SNAPSHOT bsi WH
ERE bsi.dbid = :dbid AND bsi.instance_number = :inst AND bsi.snap_id = :bid ) bt ) WHERE time_secs >= 0 ORDER BY source ASC, time_secs DESC, log_id ASC |
| 70rk1bv27r0hd | INSERT INTO A_A (AAA, BBB) VALUES (:B2 , :B1 ) |
| 72449rta1ztm9 | UPDATE T_DPLS SET FLOWID_DHMX = NULL, XDCS=0 WHERE FLOWID_DHMX = :B1 |
| 7tx50ncu1kxgm | select INST_ID, REFCOUNT from gv$global_transaction where FORMATID = :1 and (GLOBALID = :2 or GLOBALID = :3) and (BRANCHID = :4 or BRANCHID = :5) |
| 7wm2h97qzr8n6 | SELECT COUNT(*) FROM T_DPLS, T_DM_YWBM WHERE T_DPLS.DH = T_DM_YWBM.DH AND TRIM(T_DM_YWBM.YWBMBH) = :B2 AND TRIM(T_DPLS.YWSHBJ) = :B3 AND TRIM(T_DPLS.YWBMBH) = :B2 AND T_DM_YWBM.TXY = :B1 AND T_DPLS.DJLY IN ('TD', 'XP', 'YB', 'XQ', 'QH', 'QQ', 'QS', 'QP', 'LT', 'ZF') AND (ID IS NOT NULL OR ZDQH IS NOT NULL) AND ROWNUM = 1 |
| 7yaqm2habcbap | DECLARE job BINARY_INTEGER := :job; next_date DATE := :mydate; broken BOOLEAN := FALSE; BEGIN PROC_SX_MAIN_XTW_RUN; :mydate := next_date; IF broken THEN :b := 1; ELSE :b := 0; END IF; END; |
| 86rdm5vs90sd6 | UPDATE T_DPLS SET SYLX=:B4 , ZJXS=:B3 , ID=:B2 WHERE FLOWID_DHMX = :B1 |
| 8aqxbpkqk7ry1 | SELECT COUNT (DISTINCT (ZDQH || ZDXH)) FROM T_JCFYHG WHERE ISBN = :B8 AND SM = :B7 AND DJ = :B6 AND TRIM(GHDWH) = TRIM(:B5 ) AND YWBMBH = :B4 AND NVL(CZRQ0, SYSDATE)>= SYSDATE - :B3 AND HGPCH = DECODE(:B2 , 0, HGPCH, DECODE(NVL(:B1 , '$'), '$', HGPCH, :B1 )) |
| 8fhbd2sf4b5gy |
INSERT INTO T_DHLS_JX (FLOWID_DJ, FLOWID_DHMX, ID, CYBH, YWBMBH, GHDWH, KFBH, YSDJ, YSRQ, CHYCH, FLOWID_TLDJHZ, THDH, YH, SL, JHFS, LSDZJHBJ, LSDDH, FLOWID_ALLZDSM, ZDQH, ZDXH, FLOWID_JCFYHG, SYLX, JHZK, FHZK, DBBZ, XBBZ, MKZL, YSSL, DJSHSL, PSSL, YJRQ, JZJTRQ, CQJTBL, XSZQ, REMARK, LRCZYBH, OKLRRQ, SHCZYBH, SHQRRQ, SHRQ, DHPCH, ZJXS, SYS, QSSL, USR_IDJB, ZDYJ, FLOWID, YJZSL, GZBJ, QSSY, FGBJ, YWSHBJ, HYLXBH, FGYWYBH, GZFLOWID, YSFLOWID, YSFLOWID_DJ, YSSHRQ, XRRQ, ADDNEW, SSDH) SELECT FLOWID_DJ, FLOWID_DHMX, ID, CYBH, YWBMBH, GHDWH, KFBH, YSDJ, YSRQ, CHYCH, FLOWID_TLDJHZ, THDH, YH, SL, JHFS, :B8 , LSDDH, FLOWID_ALLZDSM, ZDQH, ZDXH, FLOWID_JCFYHG, SYLX, JHZK, FHZK, DBBZ, XBBZ, MKZL, YSSL, DJSHSL, PSSL, YJRQ, JZJTRQ, CQJTBL, XSZQ, REMARK, LRCZYBH, OKLRRQ, SHCZYBH, SHQRRQ, :B4 , DHPCH, ZJXS, SYS, QSSL, :B5 , :B7 , FLOWID, YJZSL, GZBJ, QSSY, '0', YWSHBJ, :B6 , :B5 , NULL, FLOWID_DHMX,
FLOWID_DJ, :B4 , SHRQ, :B3 , :B2 FROM T_DHLS_JX@C_LINK_SL_WL WHERE FLOWID_DHMX = :B1 |
| 8uwt1j4s0a50f | SELECT MIN(FLOWID) FLOWID, ZDQH, ZDXH, SUM(FYSHL - YDHCS) CS FROM T_JCFYHG WHERE ISBN = :B8 AND SM = :B7 AND DJ = :B6 AND TRIM(GHDWH) = TRIM(:B5 ) AND YWBMBH = :B4 AND NVL(CZRQ0, SYSDATE)>= SYSDATE - :B3 AND NVL(HGPCH, '$') = DECODE(:B2 , 0, HGPCH, DECODE(NVL(:B1 , '$'), '$', HGPCH, :B1 )) GROUP BY ZDQH, ZDXH |
| 9dhn1b8d88dpf |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.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 from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.nex
t_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) 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 l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1),
decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (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# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.cla
ss_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name
= 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID |
| 9q0c652wgpdh9 | select flowID, lx, cjrq, worker, title, usr_create, t_user.name from t_news, t_user where t_user.usr_id=usr_create and lx='XX' and isread='0' and WORKER='YX09' and rownum<=1 order by cjrq asc |
| 9s3pq2mxc6cc5 | INSERT INTO A_A (AAA) VALUES (:B1 ) |
| a6msvwvtbx3ma | begin PROC_DHSP_GLYJ_HF(as_flowid_dhmx=>:as_flowid_dhmx, errcode=>:errcode, errtext=>:errtext); end; |
| arwg6g27pvsw9 | SELECT Count(*) rowcount FROM T_KCSM T1 , T_KCSM_YWBM T WHERE T1.ID = T.ID AND T.YWBMBH =:YWBMBH And t1.sm like :sm |
| asyrgufuh7usn | SELECT COUNT(*) FROM T_XHD_XHQPHZ WHERE YSPBJ='2' AND YWBMBH=:B2 AND SPCZYBH=:B1 |
| axfcq597829h6 | select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag, inst_id from sys.ts$, GV$FILESPACE_USAGE where ts# = tablespace_id and online$ != 3 and (changescn_wrap > PITRSCNWRP or (changescn_wrap = PITRSCNWRP and changescn_base >= PITRSCNBAS)) and inst_id != :inst and (changescn_wrap > :w or (changescn_wrap = :w and changescn_base >= :b)) |
| b2sbn8wxrncp4 | SELECT COUNT(*) FROM T_JCDD A, T_JCZDML B, T_GHDW_YWBM C WHERE A.ZDQH = B.ZDQH AND A.ZDXH = B.ZDXH AND A.YWBMBH = B.YWBMBH AND B.GHDWH = C.GHDWH AND B.YWBMBH = :B2 AND C.YWYBH = :B1 AND EXISTS(SELECT 1 FROM T_DM WHERE DH = A.DH AND A.YXRQ>=TRUNC(SYSDATE) + :B3 AND A.YXRQ <= TRUNC(SYSDATE) + T_DM.ZTSJ + :B3 ) |
| bmvk60zs31svb | Select '0' as xz, a.isbn, a.sm, a.dj, a.cbny, b.hybh, (Select mc From t_ghdw Where bh=b.hybh) As hymc, b.hybh1, (Select mc From t_ghdw Where bh=b.hybh1) As hymc1, b.dbrq, b.jhzk, b.sylx, b.jhths1 As bhcs, b.dhs, b.kcs, b.lsdkc, b.tds, b.xss, a.id, b.ywbmbh, decode(b.xss, 0, Null, round((b.kcs+b.lsdkc)/b.xss*100, 2)) As cxb, decode(b.tds, 0, Null, round(b.kcs/b.tds*100, 2)) As ctb, decode(b.dhs, 0, Null, round((b.xss)/b.dhs*100, 2)) as xjb, b.jhzk1, b.mustflag, jhths1 As bhcs_old, mustflag as mustflag_old, decode(lx, '0', '??', '1', '??') as lx, decode(nvl(a.zdsflag, '0'), '0', '', '?') as zdsflag, decode(nvl(a.zdsflag, '0'), '0', null, a.kcmin) as kcmin, decode(nvl(a.zdsflag, '0'), '0', null, a.kcmax) as kcmax, (select mc from t_bb where bh=a.bb) as bbmc, xcs2, JHTHS2 From t_kcsm_all a, t_tmp_znjhth b Where a.id=b.id And b.czybh=:as_czybh and sjlx='0' |
| 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.schedule_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 |
| c6zrjhh2824au | SELECT COUNT(1), COUNT(DISTINCT T_KCSM.ID), NVL(SUM(T_FHMX.SFCS), 0), SUM(T_FHMX.SFCS * T_KCSM.DJ), SUM(T_FHMX.SYS) FROM T_FHMX, T_KCSM, T_DM_YWBM WHERE T_KCSM.ID = T_FHMX.ID AND T_DM_YWBM.DH=T_FHMX.DH AND T_DM_YWBM.YWBMBH=T_FHMX.YWBMBH AND T_FHMX.DJLY<>'QC' AND T_FHMX.DBRQ>=DATE'2012-11-21' AND T_FHMX.DBRQ<DATE'2012-12-21'+1 AND trim(T_FHMX.YWBMBH) ='000001' |
| c8gnrhxma4tas | SELECT owner#, property FROM sys.wri$_adv_tasks WHERE id = :1 |
| cbr96xv1g9g5j |
select ysdjh as ysddlsh, djrq, djly, dh, dm, (select mc from t_bb where bh=a.bb) as bbmc, isbn, sm, dj, xsds, xdcs, wcxdcs, phcs, zt, reason, zdqh, zdxh, pfpch, fyjhpc, fyrq, ywbmbh, cybh, id, ddfk_remark, ddfk_type, ddfk_date from (Select T_DPLS.TDPCH As ysdjh, (Select ddfk_remark From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_remark, (Select ddfk_type From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_type, (Select ddfk_date From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_date, decode(nvl(t_dpls.ysddlsh, 0), 0, t_dpls.czrq, (Select djrq From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh)) djrq, t_dpls.zdqh, t_dpls.zdxh, decode(t_dpls.qsclfs, '0', '????', '1', '????', '3', '????') As qsclfs, decode(t_dpls.spbj, '1', '????', '') As fhyq, t_dpls.dh, (Select dm From t_dm Where dh = t_dpls.dh) As dm, (Select nvl(lsdbj, '0') From t_dm_ywbm Where dh = t_dpls.dh And ywbmbh = t_dpls.ywbmbh) As lsdbj, T_jczdml.isbn As isbn, t_jczdml.sm A
s sm, t_jczdml.dj As dj, t_jczdml.bb As bb, t_dpls.xsds, decode(t_dpls.ywshbj, '1', t_dpls.xdcs, 0) As xdcs, t_dpls.wcxdcs, t_dpls.phcs, Case When /*t_dpls.XDCS = 0 AND*/ YWSHBJ <> '1' Then '???' When t_dpls.XDCS = 0 And YWSHBJ = '1' Then '???' When t_dpls.phcs > 0 And (Select Count(1) From t_fhmx, t_fhhz Where t_fhhz.pfpch = t_fhmx.pfpch And t_fhmx.zdh = t_dpls.dbdh) > 1 Then '???' When t_dpls.XDCS > 0 And t_dpls.xdcs = t_dpls.wcxdcs And t_dpls.PHCS = 0 Then '???' When t_dpls.phcs > 0 Then '???' When t_dpls.XDCS > 0 Then '???' End As ZT, decode(t_dpls.djly, 'TD', '??', 'XP', '??', 'YB', '??', 'XQ', '??', 'QH', '??', 'QQ', '??', 'QS', '??', 'QP', '??', 'LT', '??', 'ZF', '??') As djly, t_dpls.CZRQ, Case When ((t_dpls.XDCS = 0 And t_dpls.YWSHBJ = '1') Or t_dpls.YWSHBJ <> '1') Then (Case When t_dpls.okbj <> '1' Then '????-' || fun_get_ddsp_cg_czy(t_dpls.fshpch) When t_dpls.ywshbj <> '1' Then '????-' || nvl(fun_get_dd
sp_yx_czy(t_dpls.dbdh), fun_get_name(t_dpls.usr_id)) When t_dpls.cq_flag = '1' Then '????' When t_dpls.cq_flag = '2' Then '????' When fun_getpmsjkc(t_dpls.id, t_dpls.ywbmbh, t_dpls.cybh) > 0 Then '????' When fun_getkykc(t_dpls.id, t_dpls.ywbmbh, t_dpls.cybh) < t_dpls.xsds Then '????' When fun_frozen_chk(t_dpls.dh, t_dpls.ywbmbh) = '1' Then '????' When t_dpls.qsclfs = '3' Then '????' End) End reason, t_dpls.ywbmbh, t_dpls.cybh, t_dpls.id, '' As pfpch, '' As fyjhpc, Null As fyrq, Null As flowid_dhmx From T_DPLS, T_jczdml Where T_DPLS.zdqh = T_jczdml.zdqh And T_DPLS.zdxh = T_jczdml.zdxh And nvl(T_DPLS.DJLY, 'AA') In ('TD', 'XP', 'YB', 'XQ', 'QH', 'QQ', 'QS', 'QP', 'LT', 'ZF') And t_dpls.id Is Null And FSHPCH Is Not Null AND SM LIKE '%?????????????%' AND (T_DPLS.ID IS NOT NULL OR T_DPLS.FLOWID_DHMX IS NOT NULL) AND TRIM(T_DPLS.YWBMBH)= '000001' Union All Select T_DPLS.TDPCH As ysdjh, (Select ddfk_remark From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk
_remark, (Select ddfk_type From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_type, (Select ddfk_date From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_date, decode(t_dpls.ysddlsh, 0, t_dpls.czrq, (Select djrq From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh)) As djrq, t_dpls.zdqh, t_dpls.zdxh, decode(t_dpls.qsclfs, '0', '????', '1', '????', '3', '????') As qsclfs, decode(t_dpls.spbj, '1', '????', '') As fhyq, t_dpls.dh, (Select dm From t_dm Where dh = t_dpls.dh) As dm, (Select nvl(lsdbj, '0') From t_dm_ywbm Where dh = t_dpls.dh And ywbmbh = t_dpls.ywbmbh) As lsdbj, t_kcsm.isbn As isbn, t_kcsm.sm As sm, t_kcsm.dj As dj, t_kcsm.bb As bb, t_dpls.xsds, t_dpls.xdcs, t_dpls.wcxdcs, t_dpls.phcs, Case When /*t_dpls.XDCS = 0 AND*/ YWSHBJ <> '1' Then '???' When t_dpls.XDCS = 0 And YWSHBJ = '1' And cq_flag = '2' Then '???' When t_dpls.XDCS = 0 And YWSHBJ = '1' And cq_flag <> '2' Then '???' When t_dpls.phcs > 0 And (Select Count(1) Fro
m t_fhmx, t_fhhz Where t_fhhz.pfpch = t_fhmx.pfpch And t_fhmx.zdh = t_dpls.dbdh) > 1 Then '???' When t_dpls.XDCS > 0 And t_dpls.xdcs = t_dpls.wcxdcs And t_dpls.PHCS = 0 Then '???' When t_dpls.phcs > 0 Then '???' When t_dpls.XDCS > 0 Then '???' End As ZT, decode(t_dpls.djly, 'TD', '??', 'XP', '??', 'YB', '??', 'XQ', '??', 'QH', '??', 'QQ', '??', 'QS', '??', 'QP', '??', 'LT', '??', 'ZF', '??') As djly, t_dpls.CZRQ, Case When ((t_dpls.XDCS = 0 And t_dpls.YWSHBJ = '1') Or t_dpls.YWSHBJ <> '1') Then (Case When t_dpls.okbj <> '1' Then '????-' || fun_get_ddsp_cg_czy(t_dpls.fshpch) When t_dpls.ywshbj <> '1' Then '????-' || nvl(fun_get_ddsp_yx_czy(t_dpls.dbdh), fun_get_name(t_dpls.usr_id)) When t_dpls.cq_flag = '1' Then '????' When t_dpls.cq_flag = '2' Then '????' When fun_getpmsjkc(t_dpls.id, t_dpls.ywbmbh, t_dpls.cybh) > 0 Then '????' When fun_getkykc(t_dpls.id, t_dpls.ywbmbh, t_dpls.cybh) < t_dpls.xsds Then '????' When fun_froz
en_chk(t_dpls.dh, t_dpls.ywbmbh) = '1' Then '????' When t_dpls.qsclfs = '3' Then '????' End) End reason, t_dpls.ywbmbh, t_dpls.cybh, t_dpls.id, (Select Min(pfpch) From t_fhmx Where zdh = t_dpls.dbdh) As pfpch, (Select Min(fhjhpc) From t_fhmx Where zdh = t_dpls.dbdh) As fyjhpc, (Select Min(fyrq) From t_fhmx Where zdh = t_dpls.dbdh) As fyrq, t_dpls.flowid_dhmx As flowid_dhmx From T_DPLS, T_kcsm Where T_DPLS.id = T_kcsm.id And FSHPCH Is Not Null And nvl(T_DPLS.DJLY, 'AA') In ('TD', 'XP', 'YB', 'XQ', 'QH', 'QQ', 'QS', 'QP', 'LT', 'ZF') AND SM LIKE '%?????????????%' AND (T_DPLS.ID IS NOT NULL OR T_DPLS.FLOWID_DHMX IS NOT NULL) AND TRIM(T_DPLS.YWBMBH)= '000001'Union All Select T_JCDD.YSDJH As ysdjh, '' ddfk_remark, '' ddfk_type, null ddfk_date, decode(t_jcdd.ysddlsh, 0, t_jcdd.czrq0, (Select djrq From t_xhd_xhqpmx Where flowid_mx = t_jcdd.ysddlsh)) As djrq, t_jcdd.zdqh, t_jcdd.zdxh, decode(t_jcdd.qsclfs, '0', '????', '1', '????', '3', '????', '4', '????',
'5', '????', '7', '????') As qsclfs, decode(t_jcdd.qsclfs, '4', '????', '5', '????', '7', '????', '') As fhyq, t_jcdd.dh, (Select dm From t_dm Where dh = t_jcdd.dh) As dm, (Select nvl(lsdbj, '0') From t_dm_ywbm Where dh = t_jcdd.dh And ywbmbh = t_jcdd.ywbmbh) As lsdbj, T_jczdml.isbn As isbn, t_jczdml.sm As sm, t_jczdml.dj As dj, t_jczdml.bb As bb, t_jcdd.xsds, 0, 0, 0, '???' As zt, decode(t_jcdd.djly, 'TD', '??', 'XP', '??', 'YB', '??', 'XQ', '??', 'QH', '??', 'QQ', '??', 'QS', '??', 'QP', '??', 'LT', '??', 'ZF', '??') As djly, t_jcdd.CZRQ0, '' As reason, t_jcdd.ywbmbh, t_jcdd.fhdh, t_jcdd.id, '' As pfpch, '' As fyjhpc, Null As fyrq, Null As flowid_dhmx From T_jcdd, t_jczdml Where T_jcdd.zdqh = t_jczdml.zdqh And t_jcdd.zdxh = T_jczdml.zdxh AND SM LIKE '%?????????????%' AND TRIM(T_JCDD.YWBMBH)= '000001') a |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| cnt0y2r7gjvh8 | Select a.hgpch, Min(a.czrq0) As bdrq, Min(a.ghdwh) As ghdwh, Min((Select mc From t_ghdw Where bh=a.ghdwh)) As hymc, Min(a.usr_id0) As ywybh, Min((Select Name From t_user Where usr_id=a.usr_id0)) As ywyxm, Min((Select dm From t_dm Where dh=a.ywbmbh)) As ywbmmc, Count(*) As zpz, Sum(a.fyshl) As zcs, Sum(a.fyshl*a.dj) As zmy, Sum(a.ydhcs) As ydhcs, min(clzt) as bdlx, min((select dm from t_dm where dh=a.chych)) as dm, sum(bcds) as mdds From t_jcfyhg a Where czrq0>:as_rq1 And czrq0<:as_rq2+1 And ywbmbh Like :as_ywbmbh And usr_id0 Like :as_ywybh And ghdwh Like :as_ghdwh and clzt like :as_bdlx and a.fyshl>0 Group By a.hgpch |
| ctt6sqgc8004p | SELECT * FROM T_WL_SJDHSJ_HZ WHERE RECEFLAG = '0' AND TRIM(RECEBMBH) = TRIM(:B1 ) AND NOT EXISTS (SELECT 1 FROM TMP_DHDJ WHERE FLOWID_DJ=T_WL_SJDHSJ_HZ.FLOWID_DJ ) |
| d53nc7j6n1057 | SELECT decode(es.name, 'cache', 0, 'dlm', 1, 'ipq', 2, 3) as client_id, (es.bytes_sent - bs.bytes_sent) as bytes FROM WRH$_IC_CLIENT_STATS es , WRH$_IC_CLIENT_STATS bs WHERE es.dbid = :dbid AND es.instance_number = :inst AND es.snap_id = :eid AND bs.dbid = :dbid AND bs.instance_number = es.instance_number AND bs.snap_id = :bid AND es.name = bs.name |
| dandq3cnh1f16 |
select ysdjh as ysddlsh, djrq, djly, dh, dm, (select mc from t_bb where bh=a.bb) as bbmc, isbn, sm, dj, xsds, xdcs, wcxdcs, phcs, zt, reason, zdqh, zdxh, pfpch, fyjhpc, fyrq, ywbmbh, cybh, id, ddfk_remark, ddfk_type, ddfk_date from (Select T_DPLS.TDPCH As ysdjh, (Select ddfk_remark From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_remark, (Select ddfk_type From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_type, (Select ddfk_date From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_date, decode(nvl(t_dpls.ysddlsh, 0), 0, t_dpls.czrq, (Select djrq From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh)) djrq, t_dpls.zdqh, t_dpls.zdxh, decode(t_dpls.qsclfs, '0', '????', '1', '????', '3', '????') As qsclfs, decode(t_dpls.spbj, '1', '????', '') As fhyq, t_dpls.dh, (Select dm From t_dm Where dh = t_dpls.dh) As dm, (Select nvl(lsdbj, '0') From t_dm_ywbm Where dh = t_dpls.dh And ywbmbh = t_dpls.ywbmbh) As lsdbj, T_jczdml.isbn As isbn, t_jczdml.sm A
s sm, t_jczdml.dj As dj, t_jczdml.bb As bb, t_dpls.xsds, decode(t_dpls.ywshbj, '1', t_dpls.xdcs, 0) As xdcs, t_dpls.wcxdcs, t_dpls.phcs, Case When /*t_dpls.XDCS = 0 AND*/ YWSHBJ <> '1' Then '???' When t_dpls.XDCS = 0 And YWSHBJ = '1' Then '???' When t_dpls.phcs > 0 And (Select Count(1) From t_fhmx, t_fhhz Where t_fhhz.pfpch = t_fhmx.pfpch And t_fhmx.zdh = t_dpls.dbdh) > 1 Then '???' When t_dpls.XDCS > 0 And t_dpls.xdcs = t_dpls.wcxdcs And t_dpls.PHCS = 0 Then '???' When t_dpls.phcs > 0 Then '???' When t_dpls.XDCS > 0 Then '???' End As ZT, decode(t_dpls.djly, 'TD', '??', 'XP', '??', 'YB', '??', 'XQ', '??', 'QH', '??', 'QQ', '??', 'QS', '??', 'QP', '??', 'LT', '??', 'ZF', '??') As djly, t_dpls.CZRQ, Case When ((t_dpls.XDCS = 0 And t_dpls.YWSHBJ = '1') Or t_dpls.YWSHBJ <> '1') Then (Case When t_dpls.okbj <> '1' Then '????-' || fun_get_ddsp_cg_czy(t_dpls.fshpch) When t_dpls.ywshbj <> '1' Then '????-' || nvl(fun_get_dd
sp_yx_czy(t_dpls.dbdh), fun_get_name(t_dpls.usr_id)) When t_dpls.cq_flag = '1' Then '????' When t_dpls.cq_flag = '2' Then '????' When fun_getpmsjkc(t_dpls.id, t_dpls.ywbmbh, t_dpls.cybh) > 0 Then '????' When fun_getkykc(t_dpls.id, t_dpls.ywbmbh, t_dpls.cybh) < t_dpls.xsds Then '????' When fun_frozen_chk(t_dpls.dh, t_dpls.ywbmbh) = '1' Then '????' When t_dpls.qsclfs = '3' Then '????' End) End reason, t_dpls.ywbmbh, t_dpls.cybh, t_dpls.id, '' As pfpch, '' As fyjhpc, Null As fyrq, Null As flowid_dhmx From T_DPLS, T_jczdml Where T_DPLS.zdqh = T_jczdml.zdqh And T_DPLS.zdxh = T_jczdml.zdxh And nvl(T_DPLS.DJLY, 'AA') In ('TD', 'XP', 'YB', 'XQ', 'QH', 'QQ', 'QS', 'QP', 'LT', 'ZF') And t_dpls.id Is Null And FSHPCH Is Not Null AND SM LIKE '%COBS????????????5DVD 2CD%' AND T_DPLS.ID IS NULL AND T_DPLS.FLOWID_DHMX IS NULL AND TRIM(T_DPLS.YWBMBH)= '000001' Union All Select T_DPLS.TDPCH As ysdjh, (Select ddfk_remark From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) dd
fk_remark, (Select ddfk_type From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_type, (Select ddfk_date From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh) ddfk_date, decode(t_dpls.ysddlsh, 0, t_dpls.czrq, (Select djrq From t_xhd_xhqpmx Where flowid_mx = t_dpls.ysddlsh)) As djrq, t_dpls.zdqh, t_dpls.zdxh, decode(t_dpls.qsclfs, '0', '????', '1', '????', '3', '????') As qsclfs, decode(t_dpls.spbj, '1', '????', '') As fhyq, t_dpls.dh, (Select dm From t_dm Where dh = t_dpls.dh) As dm, (Select nvl(lsdbj, '0') From t_dm_ywbm Where dh = t_dpls.dh And ywbmbh = t_dpls.ywbmbh) As lsdbj, t_kcsm.isbn As isbn, t_kcsm.sm As sm, t_kcsm.dj As dj, t_kcsm.bb As bb, t_dpls.xsds, t_dpls.xdcs, t_dpls.wcxdcs, t_dpls.phcs, Case When /*t_dpls.XDCS = 0 AND*/ YWSHBJ <> '1' Then '???' When t_dpls.XDCS = 0 And YWSHBJ = '1' And cq_flag = '2' Then '???' When t_dpls.XDCS = 0 And YWSHBJ = '1' And cq_flag <> '2' Then '???' When t_dpls.phcs > 0 And (Select Count(1) F
rom t_fhmx, t_fhhz Where t_fhhz.pfpch = t_fhmx.pfpch And t_fhmx.zdh = t_dpls.dbdh) > 1 Then '???' When t_dpls.XDCS > 0 And t_dpls.xdcs = t_dpls.wcxdcs And t_dpls.PHCS = 0 Then '???' When t_dpls.phcs > 0 Then '???' When t_dpls.XDCS > 0 Then '???' End As ZT, decode(t_dpls.djly, 'TD', '??', 'XP', '??', 'YB', '??', 'XQ', '??', 'QH', '??', 'QQ', '??', 'QS', '??', 'QP', '??', 'LT', '??', 'ZF', '??') As djly, t_dpls.CZRQ, Case When ((t_dpls.XDCS = 0 And t_dpls.YWSHBJ = '1') Or t_dpls.YWSHBJ <> '1') Then (Case When t_dpls.okbj <> '1' Then '????-' || fun_get_ddsp_cg_czy(t_dpls.fshpch) When t_dpls.ywshbj <> '1' Then '????-' || nvl(fun_get_ddsp_yx_czy(t_dpls.dbdh), fun_get_name(t_dpls.usr_id)) When t_dpls.cq_flag = '1' Then '????' When t_dpls.cq_flag = '2' Then '????' When fun_getpmsjkc(t_dpls.id, t_dpls.ywbmbh, t_dpls.cybh) > 0 Then '????' When fun_getkykc(t_dpls.id, t_dpls.ywbmbh, t_dpls.cybh) < t_dpls.xsds Then '????' When fun_fr
ozen_chk(t_dpls.dh, t_dpls.ywbmbh) = '1' Then '????' When t_dpls.qsclfs = '3' Then '????' End) End reason, t_dpls.ywbmbh, t_dpls.cybh, t_dpls.id, (Select Min(pfpch) From t_fhmx Where zdh = t_dpls.dbdh) As pfpch, (Select Min(fhjhpc) From t_fhmx Where zdh = t_dpls.dbdh) As fyjhpc, (Select Min(fyrq) From t_fhmx Where zdh = t_dpls.dbdh) As fyrq, t_dpls.flowid_dhmx As flowid_dhmx From T_DPLS, T_kcsm Where T_DPLS.id = T_kcsm.id And FSHPCH Is Not Null And nvl(T_DPLS.DJLY, 'AA') In ('TD', 'XP', 'YB', 'XQ', 'QH', 'QQ', 'QS', 'QP', 'LT', 'ZF') AND SM LIKE '%COBS????????????5DVD 2CD%' AND T_DPLS.ID IS NULL AND T_DPLS.FLOWID_DHMX IS NULL AND TRIM(T_DPLS.YWBMBH)= '000001'Union All Select T_JCDD.YSDJH As ysdjh, '' ddfk_remark, '' ddfk_type, null ddfk_date, decode(t_jcdd.ysddlsh, 0, t_jcdd.czrq0, (Select djrq From t_xhd_xhqpmx Where flowid_mx = t_jcdd.ysddlsh)) As djrq, t_jcdd.zdqh, t_jcdd.zdxh, decode(t_jcdd.qsclfs, '0', '????', '1', '????', '3', '????', '4', '??
??', '5', '????', '7', '????') As qsclfs, decode(t_jcdd.qsclfs, '4', '????', '5', '????', '7', '????', '') As fhyq, t_jcdd.dh, (Select dm From t_dm Where dh = t_jcdd.dh) As dm, (Select nvl(lsdbj, '0') From t_dm_ywbm Where dh = t_jcdd.dh And ywbmbh = t_jcdd.ywbmbh) As lsdbj, T_jczdml.isbn As isbn, t_jczdml.sm As sm, t_jczdml.dj As dj, t_jczdml.bb As bb, t_jcdd.xsds, 0, 0, 0, '???' As zt, decode(t_jcdd.djly, 'TD', '??', 'XP', '??', 'YB', '??', 'XQ', '??', 'QH', '??', 'QQ', '??', 'QS', '??', 'QP', '??', 'LT', '??', 'ZF', '??') As djly, t_jcdd.CZRQ0, '' As reason, t_jcdd.ywbmbh, t_jcdd.fhdh, t_jcdd.id, '' As pfpch, '' As fyjhpc, Null As fyrq, Null As flowid_dhmx From T_jcdd, t_jczdml Where T_jcdd.zdqh = t_jczdml.zdqh And t_jcdd.zdxh = T_jczdml.zdxh AND SM LIKE '%COBS????????????5DVD 2CD%' AND T_JCDD.ID IS NULL AND TRIM(T_JCDD.YWBMBH)= '000001') a |
| df03gsnzb7nvy | SELECT l.latch#, l.gets, l.misses, l.sleeps, l.immediate_gets, l.spin_gets, COUNT ( * ) n_latches FROM v$latch l, v$latch_children lc WHERE l.latch# = lc.latch#(+) AND l.gets > 0 GROUP BY l.latch#, l.gets, l.misses, l.sleeps, l.immediate_gets, l.spin_gets |
| f3223cb4ng6hq |
select next_run_date, obj#, run_job, sch_job from (select decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) next_run_date, a.obj# obj#, decode(bitand(a.flags, 16384), 0, 0, 1) run_job, a.sch_job sch_job from (select p.obj# obj#, p.flags flags, p.next_run_date next_run_date, p.job_status job_status, p.class_oid class_oid, p.last_enabled_time last_enabled_time, p.instance_id instance_id, 1 sch_job from sys.scheduler$_job p where bitand(p.job_status, 3) = 1 and ((bitand(p.flags, 134217728 + 268435456) = 0) or (bitand(p.job_status, 1024) <> 0)) and bitand(p.flags, 4096) = 0 and ((p.instance_id is not null and (to_char(p.instance_id) = :1)) or (p.instance_id is null and p.class_oid is not null and p.class_oid in (select b.obj# from sys.scheduler$_class b where bitand(b.flags, :2) <> 0 and lower(b.affinity) = lower(:3)))) UNION ALL select q.obj#, q.flags, q.next_run_date, q.job_status, q.class_oid, q.last_enabled_time, q.insta
nce_id, 1 from sys.scheduler$_lightweight_job q where bitand(q.job_status, 3) = 1 and ((bitand(q.flags, 134217728 + 268435456) = 0) or (bitand(q.job_status, 1024) <> 0)) and bitand(q.flags, 4096) = 0 and ((q.instance_id is not null and (to_char(q.instance_id) = :4)) or (q.instance_id is null and q.class_oid is not null and q.class_oid in (select c.obj# from sys.scheduler$_class c where bitand(c.flags, :5) <> 0 and lower(c.affinity) = lower(:6)))) UNION ALL select j.job, 0, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), 1, NULL, from_tz(cast(j.next_date as timestamp), to_char(systimestamp, 'TZH:TZM')), j.field1, 0 from sys.job$ j where j.field1 is not null and j.field1 > 0 and j.field1 = :7 and j.this_date is null) a order by 1) where rownum = 1 |
| fk21qdtwf2967 |
INSERT INTO "T_XHD_XHQPMX" "A1" ("FLOWID_MX", "FLOWID_HZ", "ID", "QPSL", "QSCLBJ", "SDRQ", "SPSL", "QSSL", "SYLX", "ZJXS", "FHZK", "KYKC", "ZPSL", "ZDSL", "ZDQH", "ZDXH", "CGYJ_KH", "SLSJ", "XDWLSJ", "LASTFHSJ", "YFCS", "LASTSHSJ", "YSCS", "FLOWID_LSD", "CHANGE", "DJLY", "DJ", "ISBN", "SM", "CHANGE1", "SPRQ", "SPCZYBH", "SBTJRQ", "DEL_SL", "CQSL", "DDFK_REMARK", "DDFK_DATE", "DDFK_TYPE") SELECT "A2"."FLOWID_MX", "A2"."FLOWID_HZ", "A2"."ID", "A2"."QPSL", "A2"."QSCLBJ", "A2"."SDRQ
", "A2"."SPSL", "A2"."QSSL", "A2"."SYLX", "A2"."ZJXS", "A2"."FHZK", "A2"."KYKC", "A2"."ZPSL", "A2"."ZDSL", "A2"."ZDQH", "A2"."ZDXH", "A2"."CGYJ_KH", "A2"."SLSJ", "A2"."XDWLSJ", "A2"."LASTFHSJ", "A2"."YFCS", "A2"."LASTSHSJ", "A2"."YSCS", "A2"."FLOWID_LSD", "A2"."CHANGE", "A2"."DJLY", "A2"."DJ", "A2"."ISBN", "A2"."SM", "A2"."CHANGE1", "A2"."SPRQ", "A2"."SPCZYBH", "A2"."SBTJRQ", "A2"."DEL_SL", "A2"."CQSL", "A2
"."DDFK_REMARK", "A2"."DDFK_DATE", "A2"."DDFK_TYPE" FROM "T_XHD_XHQPMX"@! "A2" WHERE "A2"."FLOWID_MX"=:B1 |
| fmu7z5kfhn55g |
WITH pm_retention AS (SELECT 'x' x, quest_ppcm_collector.get_ppcm_parameter ( 'PM_SNAPSHOT_RETENTION_DAYS' ) pm_snapshot_retention_days FROM DUAL), pm_job AS (SELECT 'x' x, owner, job_name, CAST (start_date AS date) start_date, CAST (last_start_date AS date) last_start_date, CAST (next_run_date AS date) next_run_date, enabled FROM dba_scheduler_jobs WHERE owner IN (SELECT SYS_CONTEXT ('USERENV', 'SESSION_USER') FROM DUAL UNION SELECT table_owner FROM user_synonyms WHERE synonym_name = 'QUEST_PPCM_SNAPSHOT') AND job_name = 'QUEST_PPCM_JOB_PM_' || SYS_CONTEXT ('USERENV', 'INSTANCE') UNION ALL SELECT 'x' x, priv_user owner, TO_CHAR (job) job_name, last_date start_date, last_date last_start_date, next_date next_run_date, case when broken='Y' then 'FALSE' else 'TRUE' end enabled FROM dba_jobs WHERE priv_user IN (SELECT SYS_CONTEXT ('USERENV', 'SESSION_USER') FROM DUAL UNION SELECT table_owner FROM user_synonyms WHERE synonym_name = 'QUEST_PPCM_SNAPSHOT') AND instance = SYS_
CONTEXT ('USERENV', 'INSTANCE') AND what = 'BEGIN quest_ppcm_collector.take_snapshot(''PM''); END;') SELECT owner, job_name, start_date, last_start_date, next_run_date, enabled, pm_snapshot_retention_days FROM pm_retention JOIN pm_job ON (pm_retention.X = pm_job.X(+)) |
| ftqph2pxsrpx7 | SELECT COUNT(1), COUNT(DISTINCT T_KCSM.ID), NVL(SUM(T_FHMX.SFCS), 0), SUM(T_FHMX.SFCS * T_KCSM.DJ), SUM(T_FHMX.SYS) FROM T_FHMX, T_KCSM, T_DM_YWBM WHERE T_KCSM.ID = T_FHMX.ID AND T_DM_YWBM.DH=T_FHMX.DH AND T_DM_YWBM.YWBMBH=T_FHMX.YWBMBH AND T_FHMX.DJLY<>'QC' AND T_FHMX.DBRQ>=DATE'2012-11-21' AND T_FHMX.DBRQ<DATE'2012-12-21'+1 AND trim(T_FHMX.YWBMBH) ='000001' AND T_KCSM.SM LIKE '%???????%' |
| gdn3ysuyssf82 | SELECT advisor_id FROM sys.wri$_adv_tasks WHERE ID = :1 |
| gj91kqrh0xzb8 | SELECT MIN(T_DM1.DMJC) AS STAT_TYPE, COUNT(DISTINCT T_KCSM.ID) AS ID, SUM(T_FHMX.SFCS) AS CS, SUM(T_FHMX.SFCS * T_KCSM.DJ) AS MY, SUM(T_FHMX.SYS) AS SY, ABS(ROUND(SUM(T_FHMX.SFCS * T_KCSM.DJ) * 100 / 108935330.78, 2)) AS ZZMYBL, DECODE(SUM(T_FHMX.SFCS), 0, 0, ROUND(SUM(T_FHMX.SYS) * 100 / SUM(T_FHMX.SFCS * T_KCSM.DJ), 2)) AS PJJZ FROM T_FHMX, T_KCSM, t_dm , T_DM T_DM1 WHERE T_FHMX.ID = T_KCSM.ID AND t_dm.dh=t_fhmx.dh and T_FHMX.DJLY<>'QC' AND T_FHMX.YWBMBH = T_DM1.DH (+) AND T_FHMX.DBRQ>=DATE'2012-11-21' AND T_FHMX.DBRQ<DATE'2012-12-21'+1 AND trim(T_FHMX.YWBMBH) ='000001' GROUP BY T_DM1.DH ORDER BY MY desc |
| gsghyzy1w1bzm | SELECT * FROM T_TMP_ZNJHTH1 WHERE CZYBH = :B2 AND SJLX = :B1 |
| gxnkcx56q8nfg |
SELECT B.ID, T_GHDW.MC AS HYBH, T_BB.MC AS BB, B.SM, TO_CHAR(B.DJ, '999999.99') AS DJ, B.ISBN, B.CBNY, B.DHS, B.FHS, B.FTS, B.THS, B.SYS, B.BFS, B.THTZ, B.KCS, B.XSS, B.JHZK, TO_CHAR(B.JHRQ, 'YYYY-MM-DD') AS JHRQ, TO_CHAR(B.DBRQ, 'YYYY-MM-DD') AS DBRQ, T_FL.MC AS FL, T_USER.NAME AS USR, b.remark, B.DHMY, B.FHMY, B.FTMY, B.THMY, B.SYMY, B.BFMY, THTZMY, B.KCMY, B.XSMY, B.DHSY, B.FHSY, B.FTSY, B.THSY, B.SYSY, B.BFSY, THTZSY, B.KCSY, B.XSSY, T_DM.DM FROM (SELECT A.*, rownum r FROM (SELECT MIN(CBNY) AS CBNY, MIN(T_KCSM.ISBN) AS ISBN, MIN(T_KCSM.SM) AS SM, MIN(T_KCSM.DJ) AS DJ, MIN(T_KCSM.BB) AS BB, MIN(T_KCSM.ID) AS ID, MIN(T_KCSM.FL) AS FL, SUM(T_HYJXC.DHS) AS DHS, SUM(T_HYJXC.FHS) AS FHS, SUM(T_HYJXC.FTS) AS FTS, SUM(T_HYJXC.THS) AS THS, SUM(T_HYJXC.SYS) AS SYS, SUM(T_HYJXC.BFS) AS BFS, SUM(T_HYJXC.KCS) AS KCS, SUM(T_HYJXC.XSS) AS XSS, SUM(T_HYJXC.DHS * DJ) AS DHMY, SUM(T_HYJXC.XSS * DJ) AS XSMY, SUM(T_HYJXC.FHS * DJ) AS FHMY, SUM(T_HYJXC.FTS * DJ) AS FTMY, SUM(T_HYJXC.THS * DJ) AS THMY,
SUM(T_HYJXC.BFS * DJ) AS BFMY, SUM(T_HYJXC.SYS * DJ) AS SYMY, SUM(T_HYJXC.THTZ * DJ) AS THTZMY, SUM(T_HYJXC.KCS * DJ) AS KCMY, SUM(ROUND(T_HYJXC.DHS*T_HYJXC.ZJXS*T_HYJXC.JHZK/100, 2)) AS DHSY, SUM(T_HYJXC.XSSY) AS XSSY, SUM(T_HYJXC.FHSY) AS FHSY, SUM(T_HYJXC.FTSY) AS FTSY, SUM(ROUND(T_HYJXC.THS*T_HYJXC.ZJXS*T_HYJXC.JHZK/100, 2)) AS THSY, SUM(ROUND(T_HYJXC.BFS*T_HYJXC.ZJXS*T_HYJXC.JHZK/100, 2)) AS BFSY, SUM(ROUND(T_HYJXC.SYS*T_HYJXC.ZJXS*T_HYJXC.JHZK/100, 2)) AS SYSY, SUM(ROUND(T_HYJXC.THTZ*T_HYJXC.ZJXS*T_HYJXC.JHZK/100, 2)) AS THTZSY, SUM(ROUND(T_HYJXC.KCS*T_HYJXC.ZJXS*T_HYJXC.JHZK/100, 2)) AS KCSY, MAX(T_HYJXC.DBRQ) AS DBRQ, MIN(T_HYJXC.HYBH) AS HYBH, MAX(T_HYJXC.JHRQ) AS JHRQ, MIN(T_HYJXC.JHZK) AS JHZK, SUM(T_HYJXC.THTZ) AS THTZ, MIN(T_HYJXC.USR_ID) AS USR, MIN(T_HYJXC.CYBH) AS CYBH, MAX(T_HYJXC.REMARK) AS REMARK FROM T_HYJXC, T_KCSM, T_GHDW_YWBM WHERE T_HYJXC.ID = T_KCSM.ID AND T_GHDW_YWBM.GHDWH=T_HYJXC.HYBH AND T_GHDW_YWBM.YWBMBH=T_HYJXC.YWBMBH AND T_HYJXC.DBRQ>=DATE'2010-11
-01' AND T_HYJXC.DBRQ<DATE'2012-12-21'+1 AND trim(T_HYJXC.YWBMBH)='000001' AND T_KCSM.SM LIKE '%???????%' GROUP BY T_HYJXC.HYBH, T_HYJXC.CYBH, T_KCSM.ID ORDER BY SM ASC) A WHERE rownum <= 50) B, T_BB, T_FL, T_DM, T_GHDW, T_USER WHERE B.BB = T_BB.BH(+) AND B.FL = T_FL.BH(+) AND B.HYBH = T_GHDW.BH(+) AND B.CYBH = T_DM.DH AND B.USR = T_USER.USR_ID(+) AND r >= 1 |