[GENERAL] getting the currval of a sequence

[Fran Fabrizio]

Hi all,

I need to do the equivalent of:

 select my_sequence.CURRVAL from Sys.dual; 

so I'm guessing its:

 select currvar('my_sequence') from ???????;

Can anyone fill in the ????  Thanks!

-Fran