Oracle自增主键设置

首先建表

create table aisr_zcktest(
 id number primary key,
 name varchar(12) not null,
 password   varchar(12) not null
);

建序列

CREATE SEQUENCE aisr_zcktest_sequence
INCREMENT BY 1 
START WITH 1 
NOMAXVALUE 
NOCYCLE 
NOCACHE 

设置触发器

create trigger aisr_zcktest_trig before
insert on aisr_zcktest for each row when (new.id is null)
begin

 select aisr_zcktest_sequence.nextval into:new.id from dual;

 end;