Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to select the last item's ID
After I inserted a row of data, how do I retrieve the auto-increment ID of
this row ? Because there might be another SQL script also inserting into
this table at the same time, it is not guaranteed that I will get the
correct ID by selecting right after inserting. Is there a function for
this? Thousands of appreciation!!!
Please tell me where I should post this question if I post the wrong newsgroup, thanks!! Received on Tue Sep 04 2001 - 07:50:47 CDT