How to access the current value and next value from a
sequence?
- 6 Answers
- 11932 Views
- I also Faced
- E-Mail Answers
Answer Posted / p.rajasekar
We cannot directly get Current value from the sequence.So
first we need to get the next value, then we can get the
current value in the same scope
select sequencename.nextval from tablename
select sequencename.currval from tablename
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is crud stand for?
What is cross join sql?
how to include numeric values in sql statements? : Sql dba
what is the command line end user interface - mysql? : Sql dba
How to avoid using cursors? What to use instead of cursor and in what cases to do so?
How long it takes to learn pl sql?
How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000
What is cross join example?
Explain what is dbms?
What are stored procedures used for?
What are the different sql languages?
What is replication id?
What is recursive join in sql?
What steps server process has to take to execute an update statement?
What are the parts of a sql statement?
