Re: update

Oracle will consider it a new value even tho' it matches the current value.. So it handles the transaction like any other update... That is:
 old value held in the rollback segment until the update with the new value is committed or rolled back

hth
.
"frank stueckler" <frank.stueckler_at_gillardon.de> wrote:

>Hi ORACLE-Freaks,
>
>can anybody tell me what happens inside an ORACLE Database (SQL Area,
>RedoLog, Rollback Segment) when I try to update a column with the same value
>the column had before?
>Does ORACLE remember the old value although the update statement contains
>the same value?
>
>Thanks for help
>Frank
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World!  Check out our new Unlimited Server. No Download or Time Limits! -----== Over 80,000 Newsgroups - 19 Different Servers! ==----- Received on Tue Oct 23 2001 - 10:56:40 CDT