Interested to Buy Any Domain ? << Click Here >> for more details...
How to access the current value and next value from a
sequence?
- 6 Answers
- 13210 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
What is triggering circuit?
Does inner join remove duplicates?
Which sql most popular?
How do you determine the current isolation level? : Transact sql
What is a primary key? Explain
Is and as keyword in pl sql?
Explain what is dbms?
How to take user input in pl sql?
What is sql dialect?
What is rollback?
How can I change database name in sql?
what is user defined functions? : Sql dba
what are dynamic queries in t-sql? : Transact sql
What is union and union all keyword in sql and what are their differences?
Can a primary key be a foreign key?
