Re: Incrementing counters
The most foolproof method for each instance of needing a unique counterid, ..
begin transaction
in the counters table find the next sequential value for the given table
store it in the counters table along with the name of the target table
insert it in the target table
commit or rollback on failure
Subject
Written By
Posted
Re: Incrementing counters
August 05, 2015 03:01PM
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.