Jagdish

• Aug 22nd, 2005

 

Yes, but the curval will get teh same value whcih is already return. 

shlomcar

• Sep 1st, 2005

 

correct answer:  
NEXTAVAL must be issued for that sequence before CURRVAL contaons a value 
 
from Oracle Server SQL references 8

Shasi

• Jan 7th, 2006

 

You can find the last number used in the session for your sequence from the below mentioned query

select last_number from user_sequences where sequence_name = <your_sequence_name>

rajanipriya

 Profile Answers by rajanipriya Questions by rajanipriya

• May 11th, 2006

 

Nextval must be used to generate a sequence number in the current user's session before currval can be referenced.