sequence on pl/sql

Question

create sequence MYSEQ_sequence
start with 100
increment by 5;

I just created the sequence in sql. I want to create pl/sql anonymous block program unit that shows the curval, and nextval of the sequence MYSEQ. Does anybody know how to put it in pl/sql?

Answer 1

A simple query will do:

SELECT MYSEQ_sequence.currval, MYSEQ_sequence.nextval
FROM DUAL

You don't even need a PL/SQL block for this.