oracle 建立自動增加主鍵的表

oracle 建立自動增加主鍵的表 //建立表
create table t (pk number primary key,name varchar2(20));

//建立序列
create sequence t_seq
increment by 1
start with 1 maxvalue 999999999;

//建立觸發器
create trigger t_trigger before insert on t for each row
begin
select t_seq.nextval into :new.pk from dual; //or ( new.pk=t_seq.nextval)
end;

//插入記錄
insert into t(name) values('aa');

http://www.cnblogs.com/skl99/archive/2009/01/06/1370450.html