Re: some doubts abt sql*plus and sqlworksheet

Correct. After you issue the delete, the record is still in the database until you issue a commit. When you issue the delete, you won't be able to see but others will until the commit is issued. The transaction is not final until rollback or commit. Since the transaction is not final, others won't be able to see the results of the transaction.

HTH,
Brian

lkw wrote:
>
> >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 Wed Dec 08 1999 - 10:12:57 CST