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 define default values for formal parameters?
How do we switch from init.ora file to asp file?
How to retrieve the count of updated rows?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
Can anyone give me information about oracle certification
What do you understand by a database object?
State the various uses of dbcc command?
What is concurrency in oracle?
if i am using dml statement in function. then i am writing select statement what was the output
What are ACID properties in databases?