Re: Update statement flow

agarwalp_at_eeism.com wrote:
> Great answers guys,
>
> No it wasn't an assignment. I am just a newbie. One question though.
> Suppose i have a table (col1 varchar2) one row, with value 'Z' stored.
> I updated a record with a simple update statement. No transaction
> involved.

*ALL UPDATES ARE PART OF SOME TRANSACTION*. Sorry to shout, but you didn't seem to hear me the first time.

>
> Update table set col1='X'
>
> And i do not commit that statement and i exit sqlplus

Upon a normal exit, SQL*plus implicitly does a commit.

> or shutdown my
> database,

Shut it down how?

> then still select * from table show col1 value as 'X'. What
> is happening in this case.

It sounds like your change is being committed.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB