Re: Simulating sequences
I'm not doing multi-row inserts, so that isn't an issue for me. I don't quite follow the concern with getting ids per connection - I want the last id inserted by the current connection. In my mind, my issue isn't with last_insert_id, it's with the update statement itself. If I can get the update to work properly, I think last_insert_id is just fine. But maybe I'm just not following your concerns fully.
Can you elaborate on what you mean by a "proper sequence table"?
Subject
Written By
Posted
Re: Simulating sequences
July 02, 2014 01:47PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.