Re: Oracle equival to SQL Server @@IDENTITY

Sean Chang wrote:

>I believe you will need 2 statements to accomplish the Insert and select:
>
>Declare
>Next_Num Number(8);
>
>begin
>
>select Your_Sequence.nextval into Next_Num from dual;
>insert into SG_MENUE (LevelName, ErstelltAm, ID#) VALUES ('Neuer bere',
>'10.10.2003',Next_Num);
>------
>end;
>/
>
>then you can return Next_Num as the newest ID# for further use.
>
>Hope this helps.
>
><snipped>
>

Surely you jest. I wrote this before and I will do it again:

insert into SG_MENUE (LevelName, ErstelltAm, ID#) VALUES ('Neuer bere', '10.10.2003',your_sequence.NEXTVAL);

What you suggest accomplishes nothing except to slow down performance.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)