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
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
How to get execution path reports on query statements?
Why do we need integrity constraints in a database?
Explain an exception and its types?
What is a database schema in oracle?
What is a parameter file in oracle?
How to create an oracle database?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How many file formats are supported to export data?
How to drop an existing table in oracle?
What is a database table in oracle?
State all possible different index configurations a table can possibly have?
Can select statements be used on views in oracle?
How to use values from other tables in update statements using oracle?
What is the Tune Query