Getting the identity of the row just inserted

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:41:20 CST