| SQL Id | SQL Text |
|---|
| 0a28ruhz01ts2 | SELECT COUNT(*) From T_BS_CONT Left Join T_PRD_PRODUCT On T_BS_CONT.productId = T_PRD_PRODUCT.Id Left Join T_STR_STORE On T_BS_CONT.storeCode = T_STR_STORE.code Left Join T_SM_SITE On T_BS_CONT.siteCode = T_SM_SITE.siteCode Left Join T_SM_SITE_USER On T_SM_SITE.Id = T_SM_SITE_USER.siteID And T_BS_CONT.Operator = T_SM_SITE_USER.usercode WHERE 1=1 AND T_BS_CONT.manageCom Like :1 and T_BS_CONT.delflag='0' ORDER BY T_BS_CONT.ID |
| 0az7czjdw8z7j | declare lbRec dbms_rcvman.lbRec_t; lbCursor dbms_rcvman.lbCursor_t; first boolean := FALSE; ret boolean; begin if (:first > 0) then first := TRUE; end if; <<next_row>> ret := dbms_rcvman.listBackup( lbRecOut => lbRec, firstCall => first, only_obsolete => TRUE, redundancy => :redundancy, piped_call => FALSE, lbCursor => lbCursor, lbState => dbms_rcvman.lbStatePck, extRlKeepSCN => NULL); if (not ret) then raise no_data_found; elsif (lbRec.pkey is not null and lbRec.is_rdf = 'YES') then :backup_type := lbRec.backup_type; :file_type := lbRec.file_type; :key := lbRec.pkey; else first := FALSE; goto next_row; end if; end; |
| 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) |
| 0w53c9wjyhk67 | select t.id, t.usercode, t.userpwd, t.username, t.siteid, t.mngBranch, t.disableFlag, t.startDate, t.endDate, t.isFinalUse, t.userType, t.moblenum, t.extusercode from t_sm_site_user t where t.delflag='0' and t.usercode=:1 |
| 15dyr87r4w2a1 | SELECT * FROM QRTZ_CRON_TRIGGERS WHERE TRIGGER_NAME = :1 AND TRIGGER_GROUP = :2 |
| 1zj4h0k2taaj7 | SELECT T.id, T.productCode, T.productName, T.productType, T.cardCode, T.mngBranch, T.applApproveFlag, T.poolFlag, T.poolProportion, T.insurPeriod, T.insurPeriodUnit, T.specialPromise, T.productState, T.checkType, T.insureType, T.version, T.delFlag, T.crtTime, T.updTime FROM T_PRD_PRODUCT T where T.delflag = '0' and T.id = :1 |
| 22356bkgsdcnh | SELECT COUNT(*) FROM X$KSPPI A, X$KSPPCV2 B WHERE A.INDX + 1 = KSPFTCTXPN AND KSPPINM = '_deferred_log_dest_is_valid' AND UPPER(KSPFTCTXVL)='TRUE' |
| 297v03ws47dp7 | SELECT T.ID, T.CODE, T.VALUE, T.ORDERNO FROM T_PAM_CONFIG_VALUE T, T_PAM_CONFIG T1 WHERE T.DELFLAG = '0' AND T1.DELFLAG = '0' AND T1.ID=T.SYSCONFIGID AND T1.TYPE = :1 AND T.CODE = :2 |
| 2dybn8g7gacdu | SELECT T_BS_CONT_GRPAPP.id, T_BS_CONT_GRPAPP.contId, T_BS_CONT_GRPAPP.grpId, T_BS_CONT_GRPAPP.occClassCode, T_BS_CONT_GRPAPP.legalCode, T_BS_CONT_GRPAPP.corprep, T_BS_CONT_GRPAPP.contactPsn, T_BS_CONT_GRPAPP.psnCustComuAddr, T_BS_CONT_GRPAPP.psnPostCode, T_BS_CONT_GRPAPP.psnTelePhone, T_BS_CONT_GRPAPP.psnFax, T_BS_CONT_GRPAPP.psnEmailAddress, T_BS_CONT_GRPAPP.psnOccClassCode, T_BS_CONT_GRPAPP.psnOccType, T_BS_CONT_GRPAPP.psnCustNo, T_BS_CONT_GRPAPP.contactPsnIdNo, T_BS_CONT_GRPAPP.primContactWay, T_BS_CONT_GRPAPP.peoples, T_BS_CONT_GRPAPP.onWorkPeoples, T_BS_CONT_GRPAPP.contactMobile, T_BS_CONT_GRPAPP.version, T_BS_CONT_GRPAPP.delFlag, T_BS_CONT_GRPAPP.crtTime, T_BS_CONT_GRPAPP.updTime, T_BS_CONT_GRP.teamName, T_BS_CONT_GRP.certType, T_BS_CONT_GRP.certNo FROM T_BS_CONT_GRPAPP, T_BS_CONT_GRP WHERE T_BS_CONT_GRP.id =T_BS_CONT_GRPAPP.grpid and T_BS_CONT_GRP.DELFLAG ='0' and T_BS_CONT_GRPAPP.contId=:1 |
| 2gfn18pmshb2p | SELECT id, contId, polId, dutyId, insuYear, payIntv, mult, prem, amnt, version, delFlag, crtTime, updTime FROM T_BS_CONT_DUTY WHERE DELFLAG ='0' and contId = :1 |
| 2k51tqtt5cj5d |
SELECT T.id, T.productCode, T.productName, T.productType, T.cardCode, T.mngBranch, T.applApproveFlag, T.poolFlag, T.poolProportion, T.insurPeriod, T.insurPeriodUnit, T.specialPromise, T.productState, T.checkType, T.version, T.delFlag, T.crtTime, T.updTime, PU.id as puId, PU.puCode, PU.puName, PU.puProportion, T.insureType, T.remark, nvl((select 1 from T_PRD_CLAUSE PC WHERE PC.prdId=T.id and PC.delFlag='0' and rownum=1), 0) as hasClause, pg.Prttpletid , pg.doctype, p.tpletclass, p.prttype, pg.id pgId, Tag.tag, tag.id tagId FROM T_SM_SITE_PROD sitePrd LEFT JOIN T_PRD_PRODUCT T ON T.id = sitePrd.prodid LEFT JOIN T_PRD_POOLUNITINFO PU ON PU.prdId=T.id and PU.delFlag='0' left join T_PRD_REFTEMPLET PG ON T.id = PG.PRODUCTID and PG.DELFLAG='0' left join T_PRT_TEMPLETINFO P on Pg.Prttpletid=p.id and p.delflag='0' left join t_tag_use_info TG on T.id=TG.USEID and tg.delflag='0' left join t_tag_base_info Tag on Tg.Tagid=Tag.Id and tag.delflag='0' where sitePrd.siteID=:1 AND sitePrd.storeID=:2 AND
T.delFlag='0' ORDER BY T.id asc, PU.id asc |
| 317v5hnvvd49h |
UPDATE wrh$_seg_stat_obj ob SET (snap_id, owner, object_name, subobject_name, tablespace_name, object_type, index_type, base_obj#, base_object_name, base_object_owner) = (SELECT so.snap_id + 1, so.oj.owner_name, so.oj.object_name, so.oj.subobject_name, so.oj.tablespace_name, so.oj.object_type, index_type, coalesce(io.base_obj#, so.base_obj#), coalesce(io.base_object_name, so.base_object_name), coalesce(io.base_object_owner, so.base_object_owner) FROM (SELECT dbid, ts#, obj#, dataobj#, object_type, base_obj#, base_object_name, base_object_owner, snap_id, dbms_swrf_internal.awr_get_object_info( ts#, obj#, dataobj#, AWR_OBJECT_INFO_TYPE(owner, object_name, subobject_name, tablespace_name, object_type)) oj FROM wrh$_seg_stat_obj) so LEFT OUTER JOIN (SELECT decode(ind.type#, 1, 'NORMAL'|| decode(bitand(ind.property, 4), 0, '', 4, '/REV'), 2, 'BITMAP', 3, 'CLUSTER', 4, 'IOT - TOP', 5, 'IOT - NESTED', 6, 'SECONDARY', 7, 'ANSI', 8, 'LO
B', 9, 'DOMAIN') as index_type, base_obj.obj# as base_obj#, base_obj.name as base_object_name, base_owner.name as base_object_owner, ind.bo# as ind_base_obj#, ind.obj# as ind_obj#, ind.dataobj# as ind_dataobj# FROM ((sys.ind$ ind JOIN sys.obj$ base_obj ON (ind.bo# = base_obj.obj#)) JOIN sys.user$ base_owner ON (base_obj.owner# = base_owner.user#))) io ON (so.oj.object_type = 'INDEX' AND so.obj# = io.ind_obj# AND so.dataobj# = io.ind_dataobj#) WHERE ob.dbid = so.dbid AND ob.ts# = so.ts# AND ob.obj# = so.obj# AND ob.dataobj# = so.dataobj#) WHERE dbid = :dbid AND object_name NOT LIKE '%MISSING%' AND object_name NOT LIKE '%TRANSIENT%' AND (object_name, NVL(subobject_name, '!')) NOT IN (SELECT name, nvl(subname, '!') FROM obj$ WHERE ob.obj# = obj$.obj#) AND (ts#, obj#, dataobj#) in (SELECT tsn_kewrseg, objn_kewrseg, objd_kewrseg FROM x$kewrtsegstat) |
| 3c1kubcdjnppq | update sys.col_usage$ set equality_preds = equality_preds + decode(bitand(:flag, 1), 0, 0, 1), equijoin_preds = equijoin_preds + decode(bitand(:flag, 2), 0, 0, 1), nonequijoin_preds = nonequijoin_preds + decode(bitand(:flag, 4), 0, 0, 1), range_preds = range_preds + decode(bitand(:flag, 8), 0, 0, 1), like_preds = like_preds + decode(bitand(:flag, 16), 0, 0, 1), null_preds = null_preds + decode(bitand(:flag, 32), 0, 0, 1), timestamp = :time where obj# = :objn and intcol# = :coln |
| 3s58mgk0uy2ws | insert into wrm$_snapshot_details (snap_id, dbid, instance_number, table_id, begin_time, end_time) values (:snap_id, :dbid, :instance_number, :bind1, :bind2, :bind3) |
| 3vb0gsp27mcvm | SELECT T_BS_CONT_ISD.id, T_BS_CONT_ISD.contId, T_BS_CONT_ISD.custId, T_BS_CONT_ISD.IsdId, T_BS_CONT_ISD.IsdType, T_BS_CONT_ISD.IsdMid, T_BS_CONT_ISD.apprlt, T_BS_CONT_ISD.IsdAddr, T_BS_CONT_ISD.IsdPost, T_BS_CONT_ISD.IsdTel, T_BS_CONT_ISD.IsdMobile, T_BS_CONT_ISD.IsdEmail, T_BS_CONT_ISD.IsdProfCode, T_BS_CONT_ISD.IsdProfType, T_BS_CONT_ISD.IsdHealThnotice, T_BS_CONT_ISD.version, T_BS_CONT_ISD.delFlag, T_BS_CONT_ISD.crtTime, T_BS_CONT_ISD.updTime, T_BS_CONT_CUST.custName, T_BS_CONT_CUST.custSex, T_BS_CONT_CUST.custBirthday, T_BS_CONT_CUST.certType, T_BS_CONT_CUST.certNo FROM T_BS_CONT_ISD, T_BS_CONT_CUST WHERE T_BS_CONT_CUST.id=T_BS_CONT_ISD.custId and T_BS_CONT_ISD.contId = :1 |
| 49s332uhbnsma | declare vsn varchar2(20); begin vsn := dbms_rcvman.getPackageVersion; :pkg_vsn:pkg_vsn_i := vsn; if vsn is not null then :pkg_vsnub4 := to_number(substr(vsn, 1, 2) || substr(vsn, 4, 2) || substr(vsn, 7, 2) || nvl(substr(vsn, 10, 2), '00')); end if; end; |
| 53txd0pcdmkhx | INSERT INTO QRTZ_FIRED_TRIGGERS (ENTRY_ID, TRIGGER_NAME, TRIGGER_GROUP, IS_VOLATILE, INSTANCE_NAME, FIRED_TIME, STATE, JOB_NAME, JOB_GROUP, IS_STATEFUL, REQUESTS_RECOVERY, PRIORITY) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12) |
| 5ms6rbzdnq16t | select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (next_date <= :2)) or ((last_date is null) and (next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)) and (this_date is null) and ((dbms_logstdby.db_is_logstdby = 0 and job < 1000000000) or (dbms_logstdby.db_is_logstdby = 1 and job >= 1000000000)) order by next_date, job |
| 61f2zhhu4hfcd | SELECT TRIGGER_NAME, TRIGGER_GROUP, NEXT_FIRE_TIME 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 |
| 6ajkhukk78nsr | begin prvt_hdm.auto_execute( :dbid, :inst_num , :end_snap_id ); end; |
| 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 |
| 6wz7u2yra387s | select col.*, com.Comments from sys.all_tab_columns col, sys.all_col_comments com where col.owner = 'TBYUSER' and col.table_name = 'T_MSG_SMS_INFO' and com.Owner (+) = 'TBYUSER' and com.Table_Name (+) = 'T_MSG_SMS_INFO' and com.Column_Name (+) = col.Column_Name order by col.column_id |
| 772s25v1y0x8k | select shared_pool_size_for_estimate s, shared_pool_size_factor * 100 f, estd_lc_load_time l, 0 from v$shared_pool_advice |
| 773s6najxhbp6 | select count(*) count from T_MBFE_SALEITEM a left join T_MBFE_SALEITEM_REP b on a.billcertino=b.billcertino where a.docCancelStatus=0 and ((a.identitytype is not null and a.insuredno is not null) or (b.identitytype is not null and b.insuredno is not null )) |
| 7b4kny24g7k5q |
SELECT P.id, P.branchNo, P.polCode, P.chiefPolCode, P.polNameEng, P.polNameChn, P.polEffDate, P.polExpDate, P.businessType, P.insurDurType, P.yieldType, P.premiumType, P.botAgeLmt, P.topAgeLmt, P.sexSaleTo, P.moneyinItrvl, P.moneyinType, P.mrType, P.uwRiskFact, P.siRiskFact, P.premAlgo, P.ageAlgo, P.cashAlgo, P.subpolOptionFlag, P.coverOptionFlag, P.faceAmntType, P.orderSeq, PP.id as productPolicyId, PP.prdId, PP.policyType, PP.policyAmnt, PP.premCalType, PP.policyPrem, PP.version, PP.delFlag, PP.crtTime, PP.updTime, D.id as dId, D.polCode, D.coverageNo, D.calCoverageNo, D.shareCoverGrp, D.mutexCoverGrp, D.coverageName, D.optionFlag, D.coveramntAlgo, D.coveramntType, D.coverClassCode, D.coverSubclsCode, D.coverIpsnClass, D.exemptDur, D.moneyinItrvl as dMoneyinItrvl, D.moCtrlTimepoint, D.cntrCtrlFlag, D.cpnstItrvlCtrl, D.derateCondition, D.version as dVersion, D.delFlag as dDelFlag, D.crtTime as dCrtTime, D.updTime as dUpdTime, D.policyId, PD.id as productDutyId, PD.dutyDesc, PD.dutyTyp
e, PD.dutyAmnt, PD.dutyPrem, PD.dutyAmntProportion FROM T_PRD_PRODUCTPOLICY PP LEFT JOIN T_PRD_POLICY P ON P.id = PP.policyId LEFT JOIN T_PRD_PRODUCTDUTY PD ON PD.productPolicyId=PP.id LEFT JOIN T_PRD_DUTY D ON D.id=PD.dutyId WHERE PP.prdId=:1 AND PP.delFlag='0' AND P.delFlag='0' AND (D.delFlag='0' or D.id is null) ORDER BY PP.mainPolFlag desc, decode(P.mrType, 'Y', 0, nvl(P.orderSeq, 0) + 1) asc, P.id asc, D.id asc |
| 7s21ufnhxbuks | SELECT id, contId, puName, puPrem, version, delFlag, crtTime, updTime FROM T_BS_PU_INFO WHERE DELFLAG ='0' and contId = :1 |
| 8d193zy7hbcvn | select au_company.company_name as MNGBRANCHNAME from au_company where au_company.company_flag = :1 |
| 8f1sjvfxuup9w | select t.*, o.*, m.comments from sys.all_tables t, sys.all_tab_comments m, sys.all_objects o where t.owner = :object_owner and t.table_name = :object_name and m.owner (+) = :object_owner and m.table_name (+) = :object_name and o.owner (+) = :object_owner and o.object_name (+) = :object_name and :object_type is not null and :sub_object is null |
| 8fycsdmnvn9z6 | SELECT COUNT(TRIGGER_NAME) FROM QRTZ_TRIGGERS WHERE NEXT_FIRE_TIME < :1 AND ((TRIGGER_STATE = :2) OR (TRIGGER_STATE = :3)) |
| 8zayt7u0r6f0u | select * from T_BS_TRAVELACC where id = :1 |
| 91k4w10zgrg4m | select object_name, object_type from sys.all_objects o where o.owner = :schema and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE') |
| 9m82p8p2d7z84 |
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 f.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 i.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 |
| a02dc5j1st112 | SELECT T_BS_CONT_POL.id, T_BS_CONT_POL.contId, T_BS_CONT_POL.polId, T_BS_CONT_POL.insuYear, T_BS_CONT_POL.payIntv, T_BS_CONT_POL.mult, T_BS_CONT_POL.prem, T_BS_CONT_POL.amnt, T_BS_CONT_POL.version, T_BS_CONT_POL.delFlag, T_BS_CONT_POL.crtTime, T_BS_CONT_POL.updTime , T_PRD_POLICY.polcode, T_PRD_POLICY.chiefPolCode, T_PRD_POLICY.polNameChn FROM T_BS_CONT_POL, T_PRD_POLICY WHERE T_BS_CONT_POL.DELFLAG ='0' AND t_bs_cont_pol.polid = T_PRD_POLICY.id and T_PRD_POLICY.delflag ='0' and T_BS_CONT_POL.contId = :1 order by T_BS_CONT_POL.id asc |
| avc77as85uysx | SELECT T_BS_CONT.id, T_BS_CONT.prtNo, T_BS_CONT.contNo, T_BS_CONT.saleChnl, T_BS_CONT.manageCom, T_BS_CONT.storeCode, T_BS_CONT.contType, T_BS_CONT.linkTabId, T_BS_CONT.linkTabName, T_BS_CONT.siteCode, T_BS_CONT.productId, T_BS_CONT.appPeoples, T_BS_CONT.bnfPeoples, T_BS_CONT.insurePeoples, T_BS_CONT.grpName, T_BS_CONT.psnOccClassCode, T_BS_CONT.psnOccType, T_BS_CONT.disputedFlag, T_BS_CONT.payMode, T_BS_CONT.coValiDate, T_BS_CONT.insuYear, T_BS_CONT.payIntv, T_BS_CONT.mult, T_BS_CONT.prem, T_BS_CONT.amnt, T_BS_CONT.polApplyDate, T_BS_CONT.coInValiDate, T_BS_CONT.specDeal, T_BS_CONT.listFlag, T_BS_CONT.disputedContent, T_BS_CONT.operator, T_BS_CONT.state, T_BS_CONT.version, T_BS_CONT.delFlag, T_BS_CONT.crtTime, T_BS_CONT.updTime, T_BS_CONT.appType, T_BS_CONT.puSumPrem, T_BS_CONT.sumPrem, T_BS_CONT.coValiTime, T_BS_CONT.coInValiTime, T_BS_CONT.icNo FROM T_BS_CONT WHERE DELFLAG ='0' and id=:1 |
| aykvshm7zsabd | select size_for_estimate, size_factor * 100 f, estd_physical_read_time, estd_physical_reads from v$db_cache_advice where id = '3' |
| bd502nbh9abbs | select s.synonym_name object_name, o.object_type from all_synonyms s, sys.all_objects o where s.owner in ('PUBLIC', :schema) and o.owner = s.table_owner and o.object_name = s.table_name and o.object_type in ('TABLE', 'VIEW', 'PACKAGE', 'TYPE', 'PROCEDURE', 'FUNCTION', 'SEQUENCE') |
| bdcknv42zt7u7 | SELECT id, contId, storeId, code, value, result, orderNo, version, delFlag, crtTime, updTime FROM T_BS_CONT_HELDECLARE WHERE DELFLAG ='0' and contId = :1 |
| bm2pwrpcr8ru6 | select sga_size s, sga_size_factor * 100 f, estd_db_time t, estd_physical_reads p from v$sga_target_advice order by sga_size |
| 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 |
| bunssq950snhf | insert into wrh$_sga_target_advice (snap_id, dbid, instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS) select :snap_id, :dbid, :instance_number, SGA_SIZE, SGA_SIZE_FACTOR, ESTD_DB_TIME, ESTD_PHYSICAL_READS from v$sga_target_advice |
| bxkwuqyra0yqk | SELECT T_BS_CONT_BNF.id, T_BS_CONT_BNF.contId, T_BS_CONT_BNF.custId, T_BS_CONT_BNF.bnfId, T_BS_CONT_BNF.bnfAddr, T_BS_CONT_BNF.bnfPost, T_BS_CONT_BNF.bnfTel, T_BS_CONT_BNF.bnfMoble, T_BS_CONT_BNF.bnfEmail, T_BS_CONT_BNF.bnfIsdrlt, T_BS_CONT_BNF.version, T_BS_CONT_BNF.delFlag, T_BS_CONT_BNF.crtTime, T_BS_CONT_BNF.updTime, T_BS_CONT_CUST.custName, T_BS_CONT_CUST.custSex, T_BS_CONT_CUST.custBirthday, T_BS_CONT_CUST.certType, T_BS_CONT_CUST.certNo FROM T_BS_CONT_BNF, T_BS_CONT_CUST WHERE T_BS_CONT_CUST.id=T_BS_CONT_BNF.custId and T_BS_CONT_BNF.contId = :1 |
| cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
| dayq182sk41ks | insert into wrh$_memory_target_advice (snap_id, dbid, instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version) select :snap_id, :dbid, :instance_number, memory_size, memory_size_factor, estd_db_time, estd_db_time_factor, version from v$memory_target_advice |
| djrsgh5jpdr1a | select count(distinct A.ID) from AU_POSITION A inner join AU_PARTYRELATION B on A.ID=B.PARTYID WHERE 1=1 |
| dp3wxhxnv70mw |
SELECT * FROM(SELECT A.*, rownum as rid FROM( select T_BS_CONT.id, T_BS_CONT.prtNo, T_BS_CONT.contNo, T_BS_CONT.saleChnl, T_BS_CONT.manageCom, T_BS_CONT.storeCode, T_BS_CONT.contType, T_BS_CONT.linkTabId, T_BS_CONT.linkTabName, T_BS_CONT.siteCode, T_BS_CONT.productId, T_BS_CONT.appPeoples, T_BS_CONT.bnfPeoples, T_BS_CONT.insurePeoples, T_BS_CONT.grpName, T_BS_CONT.psnOccClassCode, T_BS_CONT.psnOccType, T_BS_CONT.disputedFlag, T_BS_CONT.payMode, T_BS_CONT.coValiDate, T_BS_CONT.insuYear, T_BS_CONT.payIntv, T_BS_CONT.mult, T_BS_CONT.prem, T_BS_CONT.amnt, T_BS_CONT.polApplyDate, T_BS_CONT.coInValiDate, T_BS_CONT.specDeal, T_BS_CONT.listFlag, T_BS_CONT.disputedContent, T_BS_CONT.operator, T_BS_CONT.version, T_BS_CONT.delFlag, T_BS_CONT.crtTime, T_BS_CONT.updTime, T_BS_CONT.appType, T_BS_CONT.puSumPrem, T_BS_CONT.sumPrem, T_BS_CONT.coValiTime, T_BS_CONT.coInValiTime, T_BS_CONT.icNo, case when t_bs_cont.state='05' and (t_bs_cont.contno is not null or t_bs_cont.contno <>'') then 'sx' el
se t_bs_cont.state end state , prd.productcode, prd.productname, case when apptype = 1 then (select T_BS_CONT_CUST.CUSTNAME || '-' || T_BS_CONT_CUST.Certno from T_BS_CONT_ISD, T_BS_CONT_CUST where T_BS_CONT_ISD.CUSTID = T_BS_CONT_CUST.id and T_BS_CONT_ISD.Contid = t_bs_cont.id ) else (select to_char(insurePeoples) from dual) end other , case when linktabname='T_BS_TRAVELACC' then ( select traTeamNo from T_BS_TRAVELACC where t_bs_cont.linkTabId=T_BS_TRAVELACC.Id ) else( select to_char(doc.docno) from dual ) end docno , (select T_BS_CONT_CUST.CUSTNAME as custname from T_BS_CONT_ISD , T_BS_CONT_CUST where T_BS_CONT_ISD.CUSTID = T_BS_CONT_CUST.id and T_BS_CONT_ISD.Contid = t_bs_cont.id and T_BS_CONT_ISD.isdid='1') as isdCustName from t_bs_cont left join T_PRD_PRODUCT prd on t_bs_cont.productid = prd.Id left join t_doc_documentinf doc on t_bs_cont.id=doc.insurapplid WHERE 1=1 AND siteCode='23983204061001' and operator='2012320400600001017' order by crttime desc) A WHERE rownum<16) WHE
RE rid >0 |
| fvkynu9xgck8h | select PGA_TARGET_FOR_ESTIMATE s, PGA_TARGET_FACTOR * 100 f, ESTD_TIME t, BYTES_PROCESSED b from v$pga_target_advice order by PGA_TARGET_FOR_ESTIMATE |
| g00cj285jmgsw | update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn |
| gf87bnxzf9raf |
select db.version_time, db.controlfile_change#, db.controlfile_sequence#, dbinc.resetlogs_time, df.last_recid, tf.last_recid, ts.last_recid, rl.last_recid, rm.last_recid, dc.last_recid, al.last_recid, bp.last_recid, do.last_recid, offr.last_recid, pc.last_recid, bs.last_recid, ldbinc.resetlogs_change#, ldbinc.resetlogs_time, ic.last_recid, rt.last_recid, grsp.last_recid, nrsp.last_recid, bcr.last_recid, decode(dc.records_used, 0, 0, dc.last_recid - dc.records_used + 1), decode(al.records_used, 0, 0, al.last_recid - al.records_used + 1), decode(bp.records_used, 0, 0, bp.last_recid - bp.records_used + 1), decode(bs.records_used, 0, 0, bs.last_recid - bs.records_used + 1), decode(do.records_used, 0, 0, do.last_recid - do.records_used + 1), decode(offr.records_used, 0, 0, offr.last_recid - offr.records_used + 1), decode(pc.records_used, 0, 0, pc.last_recid - pc.records_used + 1)into :vertime, :cfscn, :cfseq, :rltime, :dfhwm, :tfhwm, :
tshwm, :rlhwm, :rmhwm, :dchwm, :alhwm, :bphwm, :dohwm, :offrhwm, :pchwm, :bshwm, :lrstscn, :lrsttime, :ichwm, :rthwm, :grsphwm, :nrsphwm, :bcrhwm, :dclwm, :allwm, :bplwm, :bslwm, :dolwm, :offrlwm, :pclwm from v$database db, v$controlfile_record_section df, v$controlfile_record_section tf, v$controlfile_record_section ts, v$controlfile_record_section rt, v$controlfile_record_section rl, v$controlfile_record_section rm, v$controlfile_record_section dc, v$controlfile_record_section al, v$controlfile_record_section bp, v$controlfile_record_section do, v$controlfile_record_section offr, v$controlfile_record_section pc, v$controlfile_record_section bs, v$controlfile_record_section ic, v$controlfile_record_section grsp, v$controlfile_record_section nrsp, v$controlfile_record_section bcr, v$database_incarnation dbinc, v$database_incarnation ldbinc where df.type = 'DATAFILE' and tf.type = 'TEMPORARY FILENAME' and ts.type = 'TABLESPACE' and rt.type = 'RE
DO THREAD' and rl.type = 'REDO LOG' and rm.type = 'RMAN CONFIGURATION' and dc.type = 'DATAFILE COPY' and al.type = 'ARCHIVED LOG' and bp.type = 'BACKUP PIECE' and do.type = 'DELETED OBJECT' and offr.type = 'OFFLINE RANGE' and pc.type = 'PROXY COPY' and bs.type = 'BACKUP SET' and ic.type = 'DATABASE INCARNATION' and grsp.type = 'GUARANTEED RESTORE POINT' and nrsp.type = 'RESTORE POINT' and bcr.type = 'DATABASE BLOCK CORRUPTION' and dbinc.incarnation#=db.recovery_target_incarnation# and ldbinc.incarnation#=db.last_open_incarnation# |
| grwydz59pu6mc | select text from view$ where rowid=:1 |