| Sequence!!! [message #146022] |
Tue, 08 November 2005 04:11  |
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
|
Member |
|
|
Hai to all,
I want to know that whats meant by sequence and its purposes.
Where it will be used.
Thanking u
regards,
prashanthgs
|
|
|
|
| Re: Sequence!!! [message #146031 is a reply to message #146022] |
Tue, 08 November 2005 04:48  |
Arun Srinath
Messages: 12
Registered: January 2005
|
Junior Member |
|
|
Sequence is an object in oracle which is used to generate unique ids for the tables.
Every time Sequence returns unique value.
It has 3 functions Prevval , Nextval ans currval.
For eg you are create a sequence A with starting value 0 and max value 100.
First time u call A.nextval, it will return 1.
next time u call A.nextval, it will return 2 ans so on.
Similarly Prevval returns the previous value of the sequence and currval, current value of the sequence.
For more information u can see oracle Sql reference.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
