Re: Getting the identity of the row just inserted

In 8i you can use the RETURNING clause to get back the sequence value just inserted.

Pre-8i, you will have to select the sequence value into a variable, then do your inserts with that.

"Einar Magnus Råberg" <einarmr_at_tihlde.org> wrote in message news:3AB0C680.14D00D6D_at_tihlde.org...
> Hi!
>
>
> If I insert a row into a table
> INSERT INTO foobar VALUES(foocounter.nextval, 'Hi', 'You');
>
> How do I get the primary key of the row I just inserted?
>
> This primary key is needed to insert a row in another table.
>
>
> -Einar
Received on Thu Mar 15 2001 - 07:45:11 CST