触发器——条件触发

CREATE OR REPLACE TRIGGER PrjIndexProject_TR
BEFORE INSERT ON PrjIndexProject
FOR EACH ROW
DECLARE TEMP_NO INT;
BEGIN
if :new.iscopyed = 0 then
begin
SELECT SPrjIndexProject.NEXTVAL INTO :NEW.PrjIndexProjectID FROM DUAL;
SELECT SPrjIndexProject.CURRVAL INTO GLOBALPKG.IDENTITY FROM DUAL;
end;
end if;
END;
 
 
 
--说明
iscopyed是PrjIndexProject表中的一个字段
根据他的值来决定是否触发序列获取新的主键





posted on 2012-07-16 19:40  onlyfew  阅读(207)  评论(0编辑  收藏  举报

导航