给表创建自增字段

建表：

create table test
(id number not null primary key,
 name varchar2 not null);

序列:

create squence add1
increment by 1
start with 1
nomaxvalue
nocycle;

触发器：

create Trigger trigger_ranran
before insert on test
for each row
begin
select add1.next.val into :new.ID from dual;
end;

插入语句的时候id就会自动增加1