
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 · 2013 阅读 · 0 评论 -
schedule job
2019/04/09 08:00:00.000000 Asia/Taipei 2900/12/31 08:00:00.000000 Asia/Taipei FREQ=DAILY;INTERVAL=1 DECLARE STARTDATETIME VARCHAR2(200); ENDDATETIME VARCHAR2(200); v_Return VARCHAR2(200); MAXDATETIME VARCHAR2(200); S_MAXDATETIME VARCHAR2(200); BEGIN STARTD原创 2020-12-21 13:28:35 · 157 阅读 · 0 评论 -
自增长主键
create sequence RTD_WETDIFF minvalue 1 maxvalue 99999999999 start with 1 increment by 1 create or replace trigger RTD_WETDIFFEQPINFOR_Trigger BEFORE insert ON RTD_WETDIFFEQPINFOR FOR EACH ROW WHEN (new.id is null) begin select RTD_WETDIFF.nextval into:new.原创 2020-12-21 13:25:14 · 165 阅读 · 0 评论 -
regexp_substr()用法
with map as (select PRODUCTNAME,sum(PRODUCTQUANTITY) as wip from base_lot where LOTSTATE in (‘Active’,‘Hold’) group by PRODUCTNAME) select a.baselinesubid, a.,map. from FPS_SAMPLINGSETTING_ACTIVE a join map on a.PRODUCTNAME = map.PRODUCTNAME where wip >原创 2020-12-21 13:22:50 · 1281 阅读 · 0 评论 -
Oracle 查看实时运行的sql
– 查询实时运行的语句,etime单位是秒 3867 SELECT ‘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 · 360 阅读 · 0 评论 -
ORACLE批量插入
create or replace PROCEDURE EXE_EQP_CONSTRAINT_TEST AS type 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 · 251 阅读 · 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 · 717 阅读 · 0 评论