Re: get id after insert

From: Troy Tinnes <q10641_at_cig.nml.mot.com>
Date: Wed, 22 Dec 1999 14:02:50 +0900
Message-ID: <38605B79.976FA232@cig.nml.mot.com>

Is the ID sequence generated? If so, you can do this:

SELECT id.CURRVAL
FROM dual;

Troy

buurd_at_my-deja.com wrote:

> Hi!
> I'd often have to get the id (triggergenerated) from a table for the
> row i just inserted. I'd hope there is a better solution than asking
> for the max(id).
>
> Tia
>
> --
> Roland Carlsson
> Certified Java programmer
> Skövde
> Sweden
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Dec 21 1999 - 23:02:50 CST