Re: Record Numbers in Oracle Tables

The syntax would be like this:

insert into table (...)
values (...)
returning <returnfield> into :returnvalue

returnfield should be your record id.

Peter Laursen

Ian Steward <isteward_at_mediaone.net> skrev i artiklen <IVUL3.9985$Ud2.334442_at_typhoon1.rdc-detw.rr.com>...
> Is there a way to return the record id after an INSERT or UPDATE ? I am
> looking for a similar capability to the IDENTITY function in SQL Server.
>
> - Ian Steward
>
>
>
Received on Mon Oct 11 1999 - 06:04:14 CDT