Answer Posted / 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 |
Post New Answer View All Answers
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
How many anonymous blocks can be defined?
Why do you use stored procedures and state some of its disadvantages?
Who developed oracle & when?
Explain what are the advantages of views?
What is the recommended interval at which to run statspack snapshots, and why?
What is null value in oracle?
 What are the oracle DML commands possible through an update strategy?
How can you use check constraints for self referential integrity?
What is oracle sid?
How do you bind variables in oracle?
Explain compound trigger in oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is PL/SQL ?
Does oracle partitioning improve performance?
