What is a sequence?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a sequence?
Rating:
A sequence is a user-defined schema object, which can generate a unique integer sequence, and is often used to generate a unique integer to act as a primary key value.
A CREATE SEQUENCE statement is used to create a sequence and while creating it, at least, a sequence-name should always be provided.
Following attributes can be assigned to a sequence:
START WITH
INCREMENT BY
MAXVALUE
MINVALUE
CACHE
By default, a sequence generates the first value as 1.
Rating:
Was this information helpful?
Other articles
- What is a deadlock and where are deadlocks encountered?
- What is DISPLAY?
- What is sqlnet.ora?
- What is a tablespace?
- What is a backup set?
