CREATE OR REPLACE PROCEDURE PROC_SYN
BEGAIN
insert into TE_TRIGGER@linksg(ID,CODE)
values (select ID,CODE from TE_TRIGGER
where exists (select 1 from TE_TRIGGER where FLAG=0));
update TE_TRIGGER
set flag=1
where flag=0;
END;
/
小弟刚接触oracle,自己写了个过程,哪位能帮我看看什么问题?
还有我想定时执行这个过程该怎么做?注:linksg是可以使用的
BEGAIN
insert into TE_TRIGGER@linksg(ID,CODE)
values (select ID,CODE from TE_TRIGGER
where exists (select 1 from TE_TRIGGER where FLAG=0));
update TE_TRIGGER
set flag=1
where flag=0;
END;
/
小弟刚接触oracle,自己写了个过程,哪位能帮我看看什么问题?
还有我想定时执行这个过程该怎么做?注:linksg是可以使用的
is
IS
BEGIN
insert into TE_TRIGGER@linksg(ID,CODE)
select ID,CODE from TE_TRIGGER
where exists (select 1 from TE_TRIGGER where FLAG=0);
update TE_TRIGGER
set flag=1
where flag=0;
END;
http://www.ofadmin.com/Oracle/kaifa/200901/20-5271.html
推荐一本电子书
精通Oracle 10g PL/SQL编程
IS
BEGIN
INSERT INTO te_trigger@linksg (ID, code)
SELECT ID, code
FROM te_trigger
WHERE EXISTS (SELECT 1
FROM te_trigger
WHERE flag = 0); UPDATE te_trigger
SET flag = 1
WHERE flag = 0;
END;