1.Create sequence
create sequence sequence_name
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 20;
2、创建触发器
create or replace trigger triger_name
before insert on table_name
referencing old as old new as new for each row
begin
select sequence_name.nextval into :new.id from dual;
end;