Interested to Buy Any Domain ? << Click Here >> for more details...
How to access the current value and next value from a
sequence?
- 6 Answers
- 13257 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
How do I remove sql developer from windows 10?
How do you optimize a stored procedure query?
What is the purpose of normalization?
Can we use distinct and group by together?
Can we use join in subquery?
Why do we use triggers?
What are different types of tables in sql?
How can you select unique records from a table?
What is nvl?
How many sql core licenses do I need?
What is the reports view in oracle sql developer?
What is the difference between unique and primary key constraints?
What is a parameter query?
What is compute?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
