Does anyone know how to get the next value of a sequence that has been created from a stored procedure in SQL?

The above talks about oracle sql commands but I can't find anywhere the equivalent SQL syntax.

This is what I was told would work on SQL but I believe it's oracle based.

select Seq_name.nextval from DUAL;