Interested to Buy Any Domain ? << Click Here >> for more details...
How to access the current value and next value from a
sequence?
- 6 Answers
- 12953 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 create an index in word?
What is t sql in sql server?
How would you convert date into julian date format?
How to revise and re-run the last sql command?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is sql key?
What is union, minus and interact commands?
How many sql databases can you have on one server?
What is package in pl sql?
What is the difference between drop and truncate commands?
How do I create a sql script?
How do you update f as m and m as f from the below table testtable?
What is a recursive join sql?
How many types of keys are there in sql?
What is sqlite used for?
