How do I get the last autoincremented value?
I have a table who's primary key is autoincremented, and I have another table that uses this value as a foreign key.
When I insert a value into the first tabe, I also want to insert a value into the second table with the primary key value that was created when the record was inserted into the first table.
How do I get the value of the last autoincremented primary key in the first table, so I can insert it as a foreign key into the second table?
Thanks very much for your help.
JT
Subject
Written By
Posted
How do I get the last autoincremented value?
May 27, 2005 12:16AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.