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
What are the uses of a database trigger?
What is different types of joins?
How to define an anonymous block?
What are the uses of Database Trigger ?
What is a cursor and what are the steps need to be taken?
What is translate in oracle?
Why packages are used in oracle?
State the various uses of dbcc command?
What is the difference between hot backup and cold backup in oracle?
How to create a new table in oracle?
What is a sub query and what are the different types of subqueries?
What is the fastest query method to fetch data from the table?
What is a relational database management system?
What is program global area (pga) in oracle?
How to filter out duplications in the returning rows using oracle?