Interested to Buy Any Domain ? << Click Here >> for more details...
How to access the current value and next value from a
sequence?
- 6 Answers
- 13450 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
Can delete statement be rollbacked?
When is the update_statistics command used?
What does bitemporal mean?
What is the need of merge statement?
How do I find duplicates in two columns?
Why do we need pl sql?
how to enter numeric values as hex numbers? : Sql dba
What is the main reason behind using an index?
What is $$ in sql?
what are the advantages and disadvantages of views in a database? : Sql dba
how are mysql timestamps seen to a user? : Sql dba
What is a scalar value in sql?
What are inbuilt functions in sql?
What is a sql instance vs database?
How do I save the results of sql query in a file?
