Exactly the expected behavior. By inserting data into a table, you started the
transaction. SQL*Plus does not automatically commit after each DML statement
and it automatically rolls back uncommitted transactions when terminated. You
should explicitly commit your work by issuing COMMIT statement before you
exit the tool. While uncommitted, the changes are invisible to other sessions.
The only exception to the rule is when you run DDL (data definition language)
statements, like CREATE TABLE: Oracle automatically commits before and
immediately after the statement execution.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Tong Li" <tongli_at_unagi.cis.upenn.edu> wrote in message 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!
>
> Tina
>
Received on Wed Oct 09 2002 - 02:29:45 CDT
