Re: Disappeared Data

Tong Li wrote:

> Hi There;
>
> I am using Oracle 9i and Win2K.
>
> I just inserted 5 rows into a table, and I was able to see the rows by
> using count(*) function.
> But if I open second sqlplus window and login as same user, the result of
> count(*) is 0.
> I only can see the inserted rows in the first window, if I close it,
> nothing will be left, I have to do insertion again.
>
> What is the problem I am having? Any hint?
> Thanks in advance!
>
> Tina

This is as it should be. Uncommited transactions are invisible to all except the session that inserted, updated, or deleted.

Daniel Morgan Received on Tue Oct 08 2002 - 17:58:41 CDT