Interested to Buy Any Domain ? << Click Here >> for more details...
How to access the current value and next value from a
sequence?
- 6 Answers
- 13195 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 you write an inner join query?
what are the differences between binary and varbinary? : Sql dba
What are the string functions in sql?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What is crud diagram?
What is java sql connection?
What is cold data?
What does (*) mean in sql?
what is the difference between a web-garden and a web-farm? : Sql dba
What are the most important ddl statements in sql?
What are sql built in functions?
Is pl sql useful?
How do you run a query?
Name three sql operations that perform a sort.
