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.

On 8/11/06, Jared Still <jkstill_at_gmail.com> wrote:

 Not a good idea IMNSHO.
>
> If someone else is hesitant to choose the seat, I have
> every right to get it if the other party has not yet
> committed to it.
>
> Committed: that's a joke.
>
> ;)
>
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>

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