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.

What you just said is impossible.

> Update table set col1='X'

That is a transaction by definition.

> And i do not commit that statement and i exit sqlplus or shutdown my
> database, then still select * from table show col1 value as 'X'. What
> is happening in this case.

Autocommit.

> but if i switch off my pc after the update statement the value in col1
> is 'Z'
>
> Please explain what is happening in both th cases. it is really
> confusing me.

No autocommit. This really isn't rocket science here. You just need to do that thing usually abbreviated to four letters that begins with "R" and ends with "M".

Perhaps a few dollars spent on Tom Kyte's two most recent books would be a good place to apply yourself.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)