用序列发生器 create sequence SEQ_INFO_ID minvalue 1 maxvalue 99999999 start with 1 increment by 1 cache 20 cycle;
用序列结合触发器就可以 create sequence SEQ_Test minvalue 1 maxvalue 99999999 start with 1 increment by 1 cache 20;create or replace trigger Trace_Test before insert on table_name for each row begin select SEQ_Test.nextval into :new.col_name from dual; end;
create sequence SEQ_INFO_ID
minvalue 1
maxvalue 99999999
start with 1
increment by 1
cache 20
cycle;
create sequence SEQ_Test
minvalue 1
maxvalue 99999999
start with 1
increment by 1
cache 20;create or replace trigger Trace_Test
before insert on table_name
for each row
begin
select SEQ_Test.nextval into :new.col_name from dual;
end;