oracle触发器

触发器

CREATE OR REPLACE TRIGGER "S_JH_RULERELATION_ID_TRIGGER"

before insert on S_JH_RULERELATION for each row
begin
select nvl(max(id),0)+1 into :new.id from S_JH_RULERELATION;
end ;

 

CREATE SEQUENCE BS_BU_RULETYPE_seq
INCREMENT BY 1
START WITH 1
MAXVALUE 1.0E20
MINVALUE 1
NOCYCLE
CACHE 20
NOORDER

--触发器
CREATE TRIGGER "BS_BU_RULETYPE_TB_TRI" BEFORE INSERT ON "BS_BU_RULETYPE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW
begin
select BS_BU_RULETYPE_seq.nextval into :new.ID from dual;
end;