第一步

create table test
(id int primary key,
name varchar2(10));

第二步 創(chuàng)建主鍵seq

create sequence test_seq increment by 1 start with 1 
minvalue 1 maxvalue 9999999999999 nocache 
order;

第三步 綁定觸發(fā)

create or replace trigger test_trigger
before insert on test
for each 
row
begin
 select  test_seq.Nextval into:new.id from dual;
end;