Re: Disappeared Data

tongli_at_unagi.cis.upenn.edu (Tong Li) wrote in news:anvgfn$rjn$1_at_netnews.upenn.edu:

> 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!

Hi Tina,

You need to COMMIT the transaction. :)

-- 
Pablo Sanchez, High-Performance Database Engineering
http://www.hpdbe.com