![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
文章平均质量分 87
Tony-甲
这个作者很懒,什么都没留下…
展开
-
Oracle DBlink的创建-查看与删除
DBlink常用于在两个Oracle数据库之间相互连接,如手工同步数据时,DBLink是最方便快捷的手段之一。1、创建DBLink语法:create public database link connect to identified by using ‘’;public指明所有用户均可使用这个DBlink,如果不指定,则只有创建者才能使用。原创 2022-10-07 11:09:38 · 1918 阅读 · 0 评论 -
schedule job
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原创 2020-12-21 13:28:35 · 111 阅读 · 0 评论 -
自增长主键
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.原创 2020-12-21 13:25:14 · 119 阅读 · 0 评论 -
regexp_substr()用法
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 >原创 2020-12-21 13:22:50 · 1149 阅读 · 0 评论 -
Oracle 查看实时运行的sql
– 查询实时运行的语句,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原创 2020-12-21 13:20:41 · 310 阅读 · 0 评论 -
ORACLE批量插入
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原创 2020-12-21 13:19:18 · 194 阅读 · 1 评论 -
指定Oracle job 节点
指定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 =>原创 2020-12-21 13:17:48 · 594 阅读 · 0 评论