oracle数据库设置一个自增量主键

create table test_auto_increase (
       pk_id number(10),
       name varchar2(10)
);

create sequence test_sq
start with 1--从一开始
increment by 1--每次增加1
nomaxvalue--不设置最大值
nocycle---一直累加不循环
nocache--不建缓冲区

create or replace trigger test_tg
before insert on test_auto_increase
for each row
begin
  select test_sq.nextval into:new.pk_id from dual;
end;

insert into test_auto_increase (name) values('mrzhan');
--查询验证

select * from test_auto_increase;

create or replace trigger 触发器名
before insert on 表名
for each row
begin
    select 序列名.nextval into:new.主键 from dual;
end;