Issue with sequence
Hi!
I created a sequence:
CREATE SEQUENCE "XXX"."FLIGHT_LEG_SEQ"
MINVALUE 0 MAXVALUE 100000 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER CYCLE ;
Sequence after inserting a row into table:
CREATE SEQUENCE "XXX"."FLIGHT_LEG_SEQ"
MINVALUE 0 MAXVALUE 100000 INCREMENT BY 1 START WITH 24 CACHE 20 NOORDER CYCLE ;
Here is the trigger that uses this sequence:
create or replace TRIGGER NEW_LEG_ID
BEFORE INSERT ON FLIGHT_LEGS
FOR EACH ROW
BEGIN
SELECT flight_leg_seq.NEXTVAL INTO :new.leg_id
FROM dual;
END;
The sequence is set to increment by 1, however the next value is 24? What could be the reason for this?
Thanks!