create sequence seq_NAME minvalue 1 maxvalue 9999999999999999999999999999 start with 181 increment by 1 cache 20; ------------------ CREATE OR REPLACE TRIGGER "TRIGGER_NAME" BEFORE INSERT ON "TABLE" FOR EACH ROW begin select seq_NAME.nextval into :new.ID from dual; end;
minvalue 1
maxvalue 9999999999999999999999999999
start with 181
increment by 1
cache 20;
------------------
CREATE OR REPLACE TRIGGER "TRIGGER_NAME" BEFORE
INSERT ON "TABLE" FOR EACH ROW
begin
select seq_NAME.nextval into :new.ID
from dual;
end;