Sequences

I have various sequences in my database set up for ids. My question is:
How can I get the current value of the sequence without creating a session
and using the currval function?

I would like to take the current value of the sequence and use it for a
value in an insert statement.

Example:

insert into users ( "user_id", "user_fname", "user_lname",
"user_email" )
values ( 'current sequence', 'Ray', 'Hunter',
'rhunter(at)enterasys(dot)com' );

Thanks,

Ray Hunter
Firmware Engineer

ENTERASYS NETWORKS

Phone: 801 887-9888
Fax: 801 972-5789
Email: rhunter(at)enterasys(dot)com <mailto:rhunter(at)enterasys(dot)com>
www: www.enterasys.com <http://www.enterasys.com>