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

Could you use flashback query for this sort of thing?

• Harvinder Singh <Harvinder.Singh_at_MetraTech.com> wrote:

> Actually I am debugging an application with
> breakpoints and it executes
> lot of nested procedures, so I was just trying to
> login to sqlplus from
> other session and want to see the state of table at
> different points of
> execution.
>
>
>
> ________________________________
>
> From: Jared Still [mailto:jkstill_at_gmail.com]
> Sent: Thursday, August 10, 2006 3:20 PM
> To: Harvinder Singh
> Cc: ORACLE-L
> Subject: Re: Is it possible to use nolock type of
> hint in query
>
>
>
> On 8/10/06, Harvinder Singh
> <Harvinder.Singh_at_metratech.com> wrote:
>
> In sql server we can use nolock hint to see the
> uncommitted data
> of the
> other sessions. Is their any equivalent hint for
> query in
> Oracle?
>
>
> I'm curious why you would want to see uncommited
> changes from another
> transaction.
>
> What action can you possibly take based on data that
> may or may not be
> committed
> at some point in the future.?
>
>
> --
> Jared Still
> Certifiable Oracle DBA and Part Time Perl Evangelist
>
>

Robert G. Freeman
Author:
Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Features (Oracle Press)
Oracle Replication (Rampant Tech Press)
Mastering Oracle8i (Sybex)
Oracle8 to 8i Upgrade Exam Cram (Coriolis <RIP>) Oracle 7.3 to 8 Upgrade Exam Cram (Coriolis <RIP>)

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