Oracle 實現自動遞增的功能

標籤：

模仿

 1 create sequence SEQ_ID 2 minvalue 1 3 maxvalue 99999999 4 start with 1 5 increment by 1 6 nocache 7 order; 8   9 建立觸發器：10  11 create trigger tri_test_id    --（1）12 before insert on test for each row  --test 是表名13 begin14 select SEQ_ID.nextval into :new.id from dual;15 end tri_test_id;16  17 create or replace trigger tri_test_id    --（2）18   before insert on S_Depart   --S_Depart 是表名19   for each row20 declare21   nextid number;22 begin23   IF :new.DepartId IS NULL or :new.DepartId=0 THEN --DepartId是列名24     select SEQ_ID.nextval --SEQ_ID正是剛才建立的25     into nextid26     from sys.dual;27     :new.DepartId:=nextid;28   end if;29 end tri_test_id;

 

執行個體

 1 CREATE SEQUENCE rsk_book_filter_seq 2 INCREMENT BY 1  3 START WITH 10000  4 NOMAXVALUE  5 NOCYCLE  6 NOCACHE  7  8 CREATE OR REPLACE TRIGGER rsk_book_filter_tri 9 BEFORE INSERT ON rsk_book_filter10 FOR EACH ROW11 BEGIN12 SELECT rsk_book_filter_seq.NEXTVAL INTO :NEW.RISK_BOOK_FILTER_ID FROM DUAL;13 END;

 

Oracle 實現自動遞增的功能