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: some doubts abt sql*plus and sqlworksheet

Re: some doubts abt sql*plus and sqlworksheet

From: lkw <lkw_at_axiomatique.com>
Date: Wed, 8 Dec 1999 11:39:46 +0800
Message-ID: <82kk73$b7h$1@newton.pacific.net.sg>


>If you issue a delete and then a select (without a commit in between),
>you will see the changes but others will not. This is called transaction
>consistency. The delete is only valid for your transaction. When you
>select, you will see the results of the delete. To make the delete valid
>for other transactions, you must commit the results.
>
>HTH,

>Brian

so is the record still in database although i can't see it? Received on Tue Dec 07 1999 - 21:39:46 CST

Original text of this message

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