2
Reply

Obtain AutoIncrement Field Data after Insert operation in Oracle

sourcehoh

sourcehoh

Mar 9 2005 1:03 AM
3.4k
I have a master table in Oracle with the primary key is an autoincrement field, so the question is how can I obtain the autoincrement field after I performed an insert operation in the table? Because I need it to insert into my detail table too... I knew in MSSQL Server, I Can use @@IDENTITY to get the identity value after insertion for my session, is that any similiar command in Oracle ?? Thank you

Answers (2)