| |
GeekInterview.com > Tech FAQs > Oracle
| Print | |
Question: what is a sequence?
|
| October 10, 2005 01:51:09 |
#2 |
| ammasmohan |
Member Since: October 2005 Total Comments: 8 |
RE: what is a sequence?
|
| A sequence is a user created database object that can be shared by multiple users to generate unique integers. A typical usage for sequences is to create a primary key value, which must be unique for each row. The sequence is generated and incremented (or decremented) by an internal Oracle routine. This can be a time-saving object because it can reduce the amount of application code needed to write asequence-generating routine. Sequence numbers are stored and generated independently of tables. Therefore, the same sequence can be used for multiple tables. |
| |
Back To Question | |
