Re: Update Question

From: W. Klotz <willyk_at_kbi-gmbh.de>
Date: Sat, 12 Oct 2002 19:00:57 +0000
Message-ID: <ao9kf7$kc3is$1@ID-157991.news.dfncis.de>

AS far as I know, Oracle does DO an update. At least the database-triggers are executed; also redo-logs are written.

Willy

On 11 Oct 2002 18:25:17 -0700, nick_wakefield_at_hotmail.com (Niko) wrote:

>Hi,
>
>Does anyone know that what the database does if you do an update and
>the value you are setting is the same as what you are setting it to.
>
>e.g
>
>SALES
>ID, VALUE
>1 1000
>2 2000
>
>
>update SALES set VALUE = 1000 where ID = 1;
>
>Does it not do the update or will it actually do the update eventhough
>the data is the same.
>
>TIA
Received on Sat Oct 12 2002 - 14:00:57 CDT