Re: Oracle equival to SQL Server @@IDENTITY

> then you can return Next_Num as the newest ID# for further use.

Or, you could just code the INSERT as Daniel has done and if you need the newest ID#, then select CURRVAL from the sequence.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"