Re: Getting primary key right after insertion into the record

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 15 Sep 2000 17:34:14 +0200
Message-ID: <969035331.1629.0.pluto.d4ee154e@news.demon.nl>

There's no need to do it that way.
In Oracle 8.0 and before you can simply select <sequencename>.nextval into <anyvariable>
before you do the insert
In Oracle 8i and beyond you can use the returning clause of the insert command.

Hth,

Sybrand Bakker, Oracle DBA

"Jump.Net" <darwin_ling_at_hotmail.com> wrote in message news:8ptego$92m$1_at_news.jump.net...
> How do I obtain the primary key ID right after a record is inserted in
> Oracle?
>
> Such primary key is generated by trigger/sequence. And I am doing it
within
> a Java JDBC environment
>
> And this has to work in a multithreaded environment.
>
> I thought about using
>
> select max(id) from table
>
> right after the insert.
>
> Would this be the best way?
>
>
Received on Fri Sep 15 2000 - 10:34:14 CDT