Guna Sagar Challa

• Mar 27th, 2006

 

Hi,

Use the following query

select <seqnam>.currval from dual@<dblinkname>

Guna Sagar Challa

yui

• Apr 11th, 2006

 

this won't work.

before using CURRVAL, you should call NEXTVAL first. otherwise you get error.

I am also looking for the solution, how to get the current value or last inserted value without call NEXTVAL.

Hari Kiran P

• May 14th, 2007

 

You can get the current value of the Sequence by querying DBA_SEQUENCES

Column name is Last_number

Thanks
Hari Kiran P.

HARI SHANKAR SHARMA

• Jul 18th, 2011

 

select aa_seq.currval from dual

Regards,
Hari Shankar Sharma