Re: Record Numbers in Oracle Tables

From: Nicolas Bronke <newsgroup_at_trinity.de>
Date: Mon, 11 Oct 1999 17:01:08 +0200
Message-ID: <3801edb5@news2.prserv.net>

Which oracle release willsupport that? I looked at the oracle documentation 7.3. There does not exist such ability.

Regards

Nicolas Bronke

> The syntax would be like this:
>
> insert into table (...)
> values (...)
> returning <returnfield> into :returnvalue
>
> returnfield should be your record id.
>
> Peter Laursen
>
> > 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.
> >
Received on Mon Oct 11 1999 - 10:01:08 CDT