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 to assign values to data fields in record variables?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
candidate key is subset of super key but not vice-verse explain
Explain the function of optimizer in oracle?
What is hash cluster in oracle?
what are different types of deletes?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What happens to the current transaction if a ddl statement is executed?
What is rowid and rownum in oracle?
What is sharded cluster?
How can we delete duplicate rows in a table?