第一步
create table test
(id int primary key,
name varchar2(10));
第二步 创建主键seq
create sequence test_seq increment by 1 start with 1
minvalue 1 maxvalue 9999999999999 nocache
order;
第三步 绑定触发
create or replace trigger test_trigger
before insert on test
for each
row
begin
select test_seq.Nextval into:new.id from dual;
end; 