create sequence processss
minvalue 1
maxvalue 999999999999
start with 31
increment by 1
;
create or replace trigger trg_t_process_config before insert on
t_process_config for each row
declare
begin
select processss.nextval into:new.id from dual;
end trg_t_process_config;
oracle中自增长触发器
原文:http://my.oschina.net/heiyexue/blog/317061