Re: How to read UNCOMMITED data in Oracle?
Date: Thu, 16 Oct 2003 01:47:25 GMT
Message-ID: <NMmjb.789054$uu5.138322_at_sccrnsc04>
"Database Guy" <dbguy101_at_hotmail.com> wrote in message
news:7fdee71c.0310151623.15840a56_at_posting.google.com...
> "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
news:<rjbjb.562792$Oz4.523703_at_rwcrnsc54>...
> > "francis70" <member41542_at_dbforums.com> wrote in message
> > news:3482578.1066194657_at_dbforums.com...
> > > I have these 2 problem? Is there a way in Oracle to read UNCOMMITED
> > > data. [snip]
> >
> > That really isn't a feature; it is a behavior to get around a poor
locking
> > model.
>
> An alternative view would be that this has long been part of the ANSI
> SQL standard, virtually all other major DBMS vendors support it, yet
> with Oracle we still can't do it.
>
>
> DG
It is an ANSI standard because a lot of databases have a brain dead concurrency model. Being a standard makes it a standard, not a feature. So if most people jumped off the Brooklyn Bridge you would also?
Why do you want to do it in Oracle? So your application isn't ACID? Jim Received on Thu Oct 16 2003 - 03:47:25 CEST