Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: keep select in transaction

Re: keep select in transaction

From: DeadLock <kokisarmiento_at_yahoo.com>
Date: 11 Apr 2005 09:27:15 -0700
Message-ID: <1113236835.300005.47810@o13g2000cwo.googlegroups.com> 





Hi,



you can request for Transaction-Level Read Consistency with the
following command at the begining of your transaction:



ALTER SESSION SET ISOLATION_LEVEL READ ONLY;


Read-only transactions see only those changes that were committed at
the time the transaction began and do not allow INSERT, UPDATE, and
DELETE statements.



Hope it helps
Received on Mon Apr 11 2005 - 11:27:15 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US