Oracle DBA 日常维护--在Oracle中建一个编号会自动增加的字段,以利于查询

1、建立序列： 

CREATE SEQUENCE checkup_no_seq 
NOCYCLE 
MAXVALUE 9999999999 
START WITH 2; 

2、建立触发器： 

CREATE OR REPLACE TRIGGER set_checkup_no 
BEFORE INSERT ON checkup_history 
FOR EACH ROW 
DECLARE 
next_checkup_no NUMBER; 
BEGIN 
--Get the next checkup number from the sequence 
SELECT checkup_no_seq.NEXTVAL 
INTO next_checkup_no 
FROM dual; 
--use the sequence number as the primary key 
--for the record being inserted 
:new.checkup_no := next_checkup_no; 
END; 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/252936/viewspace-711503/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/252936/viewspace-711503/