Home » SQL & PL/SQL » SQL & PL/SQL » Sequence - Difference between Order and Noorder
Sequence - Difference between Order and Noorder [message #932] Wed, 13 March 2002 23:51 Go to next message
Sowrirajan
Messages: 4
Registered: March 2002
Junior Member
What is difference between order and noorder in Create Sequence statement ? It is saying it will be generated in the order of request . what does it mean ?

Report message to a moderator

Re: Sequence - Difference between Order and Noorder [message #934 is a reply to message #932] Thu, 14 March 2002 00:01 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
ORDER
-----
Specify ORDER to guarantee that sequence numbers are generated in order of request. You may want to use this clause if you are using the sequence numbers as timestamps. Guaranteeing order is usually not important for sequences used to generate primary
keys. ORDER is necessary only to guarantee ordered generation if you are using Oracle with the Parallel Server option in parallel mode.If you are using exclusive mode, sequence numbers are always
generated in order.

NOORDER
-------
Specify NOORDER if you do not want to guarantee sequence numbers are generated in order of request. This is the default.

Report message to a moderator

Previous Topic: Urgent!! editing distance
Next Topic: PL/SQL ERROR, TRIGGER PROBLEM
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 04:15:02 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.