App20134833944的博客

DBlink常用于在两个Oracle数据库之间相互连接，如手工同步数据时，DBLink是最方便快捷的手段之一。1、创建DBLink语法：create public database link connect to identified by using ‘’;public指明所有用户均可使用这个DBlink,如果不指定，则只有创建者才能使用。

2019/04/09 08:00:00.000000 Asia/Taipei2900/12/31 08:00:00.000000 Asia/TaipeiFREQ=DAILY;INTERVAL=1DECLARESTARTDATETIME VARCHAR2(200);ENDDATETIME VARCHAR2(200);v_Return VARCHAR2(200);MAXDATETIME VARCHAR2(200);S_MAXDATETIME VARCHAR2(200);BEGINSTARTD

create sequence RTD_WETDIFFminvalue 1maxvalue 99999999999start with 1increment by 1create or replace trigger RTD_WETDIFFEQPINFOR_Trigger BEFOREinsert ON RTD_WETDIFFEQPINFOR FOR EACH ROW WHEN (new.id is null)begin select RTD_WETDIFF.nextval into:new.

with map as (select PRODUCTNAME,sum(PRODUCTQUANTITY) as wip from base_lot where LOTSTATE in (‘Active’,‘Hold’) group by PRODUCTNAME)selecta.baselinesubid,a.,map. from FPS_SAMPLINGSETTING_ACTIVE a join map on a.PRODUCTNAME = map.PRODUCTNAMEwhere wip &gt

– 查询实时运行的语句,etime单位是秒 3867SELECT ‘ps -ef|grep ’ || SPID PS,/* ‘alter system KILL session ‘’’||B.sid||’, ‘||B.serial#||’’’ immediate;’ KILL_SESSION,/B.INST_ID,B.SID,B.SERIAL#,B.USERNAME,A.SQL_ID,B.EVENT,/ROUND(B.LAST_CALL_ET / 3600) “SES_T(小时)”,/T

create or replace PROCEDURE EXE_EQP_CONSTRAINT_TEST AStype eqp_constraint_type is table of eqp_constraint_temp%rowtype index by pls_integer;cursor curr is select * from s_eqp_constraint;–cursor currRowid is select rowid from eqp_constraint_test;eqp

指定Oracle job 节点–exec DBMS_SCHEDULER.SET_ATTRIBUTE(name => ‘RPT_SUMMARY_MFG_DAILY’,attribute => ‘INSTANCE_ID’, value => ‘1’);–exec DBMS_SCHEDULER.SET_ATTRIBUTE(name => ‘RPT_SUMMARY_MFG_DAILY’,attribute => ‘INSTANCE_STICKINESS’, value =>