在oracle中，為了方便常常用觸發(fā)器及序列結(jié)合起來(lái)實(shí)現(xiàn)      

先建表、再建序列、然后是觸發(fā)器，最后測(cè)試

=============================================                 

                        create table foo(
                           id number primary key,
                           data varchar2(100));
                         
                        create sequence foo_seq;
                         
                        create or replace trigger bifer_foo_id_pk
                           before insert
                             on foo
                             for each row
                        begin
                           select foo_seq.nextval into :new.id from dual;
                        end;
                        /
                         
                        insert into foo(data)
                           values(‘Chirstopher‘);
                         
                        insert into foo(id,data)
                           values(5,‘Sean‘);
                         
                        select * from foo;