Skip to Main Content

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!

min value of sequence

user613954Aug 3 2017 — edited Aug 4 2017

Hi Team,

create sequence s increment by 10 start with 100 minvalue 5 maxvalue 200 cycle cache 20;

I have created this sequence, but I am not able to understand whats the purpose of minvalu 5. I am able to get the value of current and next using below command, then why we have minval..

select s.nextval from dual;

select s.currval from dual;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 1 2017
Added on Aug 3 2017
15 comments
2,969 views