Skip to Main Content

Oracle Database Discussions

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!

Sequence with negative values (reverse sequence)

Ashish Kr MahantaMay 11 2017 — edited May 12 2017

Dear All,

Can you please suggest how this sequence will work? Will it start with -10 and then proceed to -11 or -9?

If you have any link to understand the reversal sequence then please provide. Here, I am confused because start with & maxvalue is same -10.

Syntax

create sequence TEST.TC_SCRIPT_ID

minvalue -2147483648

maxvalue -10

start with -10

increment by -1

nocache;

Regards,

Ashish Kumar Mahanta

This post has been answered by Ashish Kr Mahanta on May 11 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2017
Added on May 11 2017
8 comments
2,647 views