How to access the current value and next value from a
sequence?
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
How do you declare a variable in pl sql?
What is the difference between delete and truncate commands?
What is nosql example?
Differentiate between pl/sql and sql?
What is union and union all keyword in sql and what are their differences?
What are triggers in sql?
Explain select statements in sql?
What is the difference between partition and index?
What are different types of statements supported by sql?
What is varchar data type in sql?
What are all the different normalization?
What is sqlservr exe?
What are aggregate and scalar functions?
Is sql an operating system?
what is the command used to fetch first 5 characters of the string? : Sql dba