In my DB i have more then 20 sequence are there i need to get all the next values
here i have written the code
please correct me
DECLARE
v_max NUMBER;
BEGIN
for rec in (select sequence_name from user_sequences where sequence_name='SEQ_ACHDETAILLOG') loop
select rec.sequence_name.nextval into v_max from dual;
dbms_output.put_line(v_max);
end loop;
END;
thanks in advance
shk