Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: update

Re: update

From: Howard J. Rogers <howardjr_at_www.com>
Date: Wed, 24 Oct 2001 08:18:51 +1000
Message-ID: <3bd5ea8e$0$9824$afc38c87@news.optusnet.com.au>


Checkout 'books' at my site, and have a look at the database architecture book. There's a description there of what happens internally when you perform an update (section 1.7).

Regards
HJR

--

Oracle Resources : http://www.geocities.com/howardjr2000
========================================


"frank stueckler" <frank.stueckler_at_gillardon.de> wrote in message
news:3bd580b7$0$223$4d4ebb8e_at_businessnews.de.uu.net...

> 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
>
>
Received on Tue Oct 23 2001 - 17:18:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US