How can I create a trigger that increments on read?
I've got a table with a single row. That row has 1 field. I need to figure out a way to auto increment the vault {in place} every time I read it. So every time a client connects for the data, and does a select it gets a new value.
I'd like to avoid locking if possible, because several machines, with several clients/threads each will be making the queries.
Locks mean they will stack up amd wait, {and in tests back up to the point of a timeout}.
Anyone have any ideas?
Subject
Views
Written By
Posted
How can I create a trigger that increments on read?
7422
August 18, 2005 07:36PM
2781
August 19, 2005 02:55AM
2483
November 01, 2006 03:50AM
2581
November 01, 2006 04:28AM
2387
August 19, 2005 12:43PM
2582
August 19, 2005 01:09PM
2333
August 19, 2005 04:33PM
2367
August 19, 2005 01:40PM
2412
August 20, 2005 12:36PM
2150
October 22, 2006 11:29PM
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.