Loading

Obtain AutoIncrement Field Data after Insert operation in Oracle

sourcehoh

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

sourcehoh21y ago
This also can retrieve the unique id for that particular session. SELECT triggername.currval FROM DUAL Anyway, thank...
0
ytram521y ago
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.
0