select sequencename.currval,sequencename.nextval from dual;

How to access the current value and next value from a
sequence?

Question Posted / sweta

6 Answers
13051 Views
I also Faced
E-Mail Answers

Answer Posted / sweta

select sequencename.currval,sequencename.nextval from dual;

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we use update in sql function?

1021

How do I remove duplicates in two columns?

1002

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1004

How to use distinct and count in sql query? Explain

978

Is it possible to update views?

932

What is an invalid partition table?

977

What is exception? What are the types of exceptions?

1045

what is row? : Sql dba

1183

What is sql clause?

1011

How can I tell if sql is running?

1015

Explain lock escalation? : Transact sql

1161

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1976

What is the difference between inner join and natural join?

966

What is data type in database?

942

What is scalar and vector?

956