oracle 设置主键自动增长

1、创建表

create table emp(

id number,

name varchar2(30)

);

2、创建序列

create sequence emp_sequence
minvalue 0
maxvalue 999999999999999999
start with 0
increment by 1
cache 20;

3、创建触发器

create trigger "emp_trigger"
before insert on 
emp for each row
declare
begin 
select emp_sequence.nextval into:new.id from dual;
end;