触发器——条件触发
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;
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表中的一个字段
根据他的值来决定是否触发序列获取新的主键
