Sequences

<p><font color="#808080" face="Verdana" size="2">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?</font><p><fontcolor="#808080" face="Verdana" size="2">I would like to take the current value of the sequence
anduse it for a value in an insert statement.</font><br /><p><font color="#808080" face="Verdana"
size="2">Example:</font><p>       <font color="#808080" face="Verdana" size="2">insert into users ( "user_id",
"user_fname","user_lname", "user_email" )</font><br />        <font color="#808080" face="Verdana" size="2">values (
'currentsequence', 'Ray', 'Hunter', 'rhunter@enterasys.com' );</font><p><font color="#808080" face="Verdana"
size="2">Thanks,</font><p><b><fontface="Verdana" size="2">Ray Hunter</font></b><br /><font face="Verdana"
size="2">FirmwareEngineer</font><p><b><font face="Verdana" size="2">ENTERASYS NETWORKS</font></b><p><font
face="Verdana"size="2">Phone:          801 887-9888</font><br /><font face="Verdana" size="2">Fax:            801
972-5789</font><br/><font face="Verdana" size="2">Email:          </font><a
href="mailto:rhunter@enterasys.com"><u><fontcolor="#0000FF" face="Verdana"
size="2">rhunter@enterasys.com</font></u></a><br/><font face="Verdana" size="2">www:            </font><a
href="http://www.enterasys.com"><u><fontcolor="#0000FF" face="Verdana" size="2">www.enterasys.com</font></u></a>