Oracle ID 自增

插入记录最大ID加1 insert into aa (id,name) values((select case when max(id) is null then 1 else max(id)+1 end from aa),'a');

1创建表

create table aa (id number(10) primary key,name varchar2(20),age number);

2创建sequence

create sequence aa_squence

3创建触发器

create trigger tg_aa
before insert on aa for each row 
declare
next_id number;
begin
select aa_squence.nextval into next_id from dual;
:new.id:=next_id;
end;/ 

4插入数据

insert into aa(name,age) values('wang',22);