用序列和触发器实现
1、create table table_name(id number,name varchar2(50));
2、create sequence sequence_name
minvalue 1 maxvalue 9999999
start with 1 increment by 1
cache 100;
3、create or replace triger triger_name
before insert on table_name
for each row
begin
select sequence_name.nextal into :new.id from dual;
end;