Oracle 实现类似SQL Server中自增字段的一个办法

相关代码如下：
1. 创建sequence：

create sequence sequ_data_datainfo increment by 1 start with 1 nocycle nocache noorder;

2. 创建触发器：

create or replace trigger trig_test
before insert on table1
for each row
declare
tmpvar number;
begin
tmpvar := 0;
select sequ_proc_associateinfo.nextval into tmpvar from dual;
:new.procid:=tmpvar;
exception
when others then
-- consider logging the error and then re-raise
raise;
end;