In Oracle you must run the "select increment_name.nextval from dual" query
and then fetch from it to retrieve the row, you can then use that value for
all of your inserts. I wouldn't recommend using *curval* since if you want
to make sure inserts are in order, some simultaneous transactions might
process before you retrive curval and therefore the insert will fail.
Ilya Sterin
-----Original Message-----
From: Nico van Leeuwen
To: [EMAIL PROTECTED]
Sent: 05/14/2001 10:24 AM
Subject: Oracle auto_increment
Hi,
I have an oracle column with an autoincrement. I was wondering how I can
retrieve the last incremented id so that I can use it as a forign key in
another update. There is a special function for this in Mysql... does
oracle
have something similar?
Kind regards,
Nico.
