Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What could be the reason that some times my sequence no jump to 21 from 3? Is it possible or I am wr

TAJDINAug 15 2015 — edited Aug 17 2015

Sir

I created a sequence like bellow

CREATE SEQUENCE  "ALIZA"."PRODUCTS_SEQ"  MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE ;

But some times I see that during inserting records into database it jumps directly to 21

What could be the reason?

Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 14 2015
Added on Aug 15 2015
41 comments
7,311 views