What is a Sequence ?
Answers were Sorted based on User's Feedback
Answer / kumar
Sequence is used for number generation.
We can create a sequence and cannot update a sequence
directly.
After creating a sequence we ca use functions nextval,
currval and setval to operate on the sequence.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / s. senthil kumar
A sequence generates a serial list of unique numbers for
numerical columns of a database's tables.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / guest
Sequence is used to provide unique values to database
object.
Is This Answer Correct ? | 0 Yes | 1 No |
How does oracle handle read consistency?
What is a tns file?
how to use sequence and what use of sequence cache
How will you write a query to get a 5th rank student from a table student_report?
Describe the different type of Integrity Constraints supported by ORACLE ?
types of indexes and the rationale behind choosing a particular index for a situation.
Are truncate and delete commands same? If so why?
what are bitmap indexes? How does they work?
How to drop a tablespace?
What are data pump export and import modes?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What are the different pseudo commands? Explain in general?