Re: How to get the last insert id

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 09 Sep 2007 14:31:05 -0700
Message-ID: <1189373456.419408@bubbleator.drizzle.com>

Frank van Bortel wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> DA Morgan wrote:

>> Frank van Bortel wrote:

>

>>> Lookup INSERT INTO ... RETURNING
>>> http://tahiti.oracle.com.

>
> Which has been suggested by many others, I realize.
> ISP merger to blame...

>>> Without doubt, Daniel has some examples in his library, too,
>>> but only 11.0, of course :)
>>> But you'll get the idea
>>> - --
>>> Regards,
>>> Frank van Bortel
>> When I mark something in the library 11g that indicates I have tested it
>> in 11g and it is functional and supported. If the functionality exists
>> in previous versions it will work there too.

>
> Somewhere in the past, you had the differences between versions.
> Lately, you seem to document only the latest and the greatest, which
> is a bit of a pity, as not many always work with the latest versions.

>> In the case of the RETURNING clause it goes back many versions.

>
>
> - --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.1 (MingW32)
>
> iD8DBQFG5CeSLw8L4IAs830RApo4AJ9YXqZd+IKRQVxBU4IYEmTVvGX14gCdG4al
> c2cU4gxH4p0cbghzmbF80i4=
> =Pb2w
> -----END PGP SIGNATURE-----
In 11g the basic SQL functionality has few changes.

Packages that are changed in 11g have a statement next to each new procedure or function indicating it is new to 11g.

Packages that are new to 11g have that indicated in the "first available" row in the first few lines.

There is also a special page
http://www.psoug.org/reference/new_in_11g.html That details those items that are new.

Hope that helps.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sun Sep 09 2007 - 16:31:05 CDT