Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Update Question
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
![]() |
![]() |