1.
-- Create sequence
create sequence SEQ_AF_JOB_PARAM
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 20;
2、创建触发器---(创建一个基于该表的before insert 触发器,在触发器中使用该SEQUENCE)
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;