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!

ORDER/NOORDER in oracle sequences

user13312943May 22 2013 — edited May 22 2013

Hi,
I am a single instance database running on Oracle 10.2.0.4.
If I have a sequence created using ORDER clause, will oracle ensure the sequence numbers are always ordered?
I understand that sequences will have gaps. That is okay. Just want to know that it will always be ordered.

Does it really matter if we use ORDER/NOORDER for single instances? What happens if we give NOORDER?

I read oracle documentation and I still have these questions.

Thank You
Sarayu

This post has been answered by Tubby on May 22 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 19 2013

Added on May 22 2013

#general-database-discussions, #order

8 comments

2,485 views