建SEQUENCE序列
CREATE SEQUENCE 序列名字(例如:"URLIMAGE_SEQ") MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 101 CACHE 10 NOORDER NOCYCLE ;
建trigger 触发器
create or replace trigger 触发器名字(例如:URLIMAGE_TRI )
before insert
on 映射的表名(例如:URLIMAGE )
for each row
begin
select 刚建的序列名(例如:URLIMAGE_seq).nextval into :new.增长字段名(例如:PICID) from dual;
end;
==================================
CREATE SEQUENCE myseq MINVALUE 1 MAXVALUE 9999 INCREMENT BY 1 START WITH 101 CACHE 10 NOORDER NOCYCLE ;
create or replace trigger mytrigger
before insert
on TABLE_ONE
for each row
begin
select myseq.nextval into :new.ID from dual;
end;