Obtain AutoIncrement Field Data after Insert operation in Oracle

Question

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

sourcehoh · Answer

This also can retrieve the unique id for that particular session. SELECT triggername.currval FROM DUAL Anyway thank...

ytram5 · Answer

From what I understand for a field in Oracle to be autonumbered there must be a Sequence associated with that table. So before you insert the row you could call the sequence for that table with sequence_name.nextval and that should return you the next number it would insert. I may be off on this I mainly work with SQL Server but everything I have gotten is off of this webpage: http://www.xefteri.com/articles/show.cfm?id=23 Click on the Identity Fields in SQL Server and Oracle article.