Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: some doubts abt sql*plus and sqlworksheet
>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