kumar vikal

• Jul 27th, 2005

 

for current value the function is :- sequence_name.currval 
and for the next value it is sequence_name.nextval

kishorebabukm

 Profile Answers by kishorebabukm 

• Sep 20th, 2005

 

I would like to give you a small example to use the sequence.currval and sequence.nextval

create sequence seq_name

start with 1

minvalue 1

maxvalue 999

increment by 1

nocycle

insert into table_name (sno,name) values (seqname.nextval,'abc');

select seqname.currval from dual

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

 

select <sequencename>.nextval from dual;

select <sequencename>.currval from dual;

or

select * from user_sequences where sequence_name = <sequencename>;

here last_number is your currval and last_number + increment_by is your nextval