How to prevent to insert a new row reacord into a subset of reacords
while the subset is being updated. or vise versa prevent the subset to
update while new row is inserted. Ex:
A 1 new
A 2 new
update to
A 1 old
A 2 old
prevent a 'A 3 new' insert into. The new row will become 'B 1 new',
preventing subset of
A 1 old
A 2 old
A 3 new
what Oracle mechanism provides such thing. The only thing I can think
about is to use the "For Update" in Updating block. Does it really
achieve such goal? Thanks for anyone's suggestion.
K Chang
Received on Thu Oct 31 2002 - 23:09:21 CST
