How to access the current value and next value from a
sequence?
- 6 Answers
- 11936 Views
- I also Faced
- E-Mail Answers
Answer Posted / chandrasekar ramasamy
select sequencename.currval from tablename
select sequencename.nextval from tablename
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
what is log shipping? : Sql dba
What is a ddl command?
What is the difference between the conventional and direct path loader? : aql loader
how many groups of data types? : Sql dba
How do I start sql profiler?
What are % type and % rowtype?
When is a declare statement required?
What jobs use sql?
What are the usages of sql?
Why is sql important?
How can I speed up sql query?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
what are rollup and cube in t-sql? : Transact sql
Can a select statement fire a trigger?
How do I find duplicates in two columns?
