Re: Precedence of function over table(s) in SQL

Sybrand,

Thanks for your response.

Correct me if I am wrong, but I was under the impression that an uncommitted transaction could see the committed data done by an inside transaction *if* the sub-transaction happens to be an "AUTONOMOUS TRANSACTION". ~nM

sybrandb_at_yahoo.com wrote in message news:<a1d154f4.0404080200.513024a7_at_posting.google.com>...
> nilendu_at_nilendu.com (Nilendu) wrote in message news:<ebaaa569.0404072158.e6a6703_at_posting.google.com>...
> > Hi All,
> >
> > Is there a way to achieve this?
> >
> > Thanks,
> >
> > ~nM
>
> Sure there is.
> Either
> a ) try to replace Oracle's optimizer by your own (not preferred)
> b) try to LEARN SQL and what a transaction is, as opposed to resorting
> to this crap (preferred)
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Thu Apr 08 2004 - 12:13:38 CDT