RE: Is it possible to use nolock type of hint in query

>>>I could see cases in which I might want to predict if I will
be able to make a reservation or not, perhaps I need 10 seats, and based on current pending transactions in queue I have a low chance of getting all ten seats on flight unless I complete my transaction within the next minute. The right design would have a status column perhaps that would be commited as "PENDING", but if we don't have that then being able to see uncommited transactions might be usfull as a way of "seeing" the pending transactions on the given flight. Not the right tool perhaps, but I still like having the option to use the tool if I decide to.

...right, at this point we are looking at a new protocol, the "Three Phaced Commit".

--
http://www.freelists.org/webpage/oracle-l