Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get ID of inserted row.

563338Mar 14 2007 — edited Mar 15 2007
Hello all!
I have table with column ID (autoincrement column).
In my PL/SQL procedure I'm inserting some values and need to get the ID of newly added row.
How can I do this?
PS. I think that 'SELECT MAX(ID) FROM MY_TABLE_NAME' doesn't much my purposes. Because my application has a lot of user and such method can return wrong information...
Please correct me if I'm wrong.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 12 2007
Added on Mar 14 2007
#general-database-discussions
8 comments
654 views