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 -> Update Question If the Data is The Same

Update Question If the Data is The Same

From: Niko <nick_wakefield_at_hotmail.com>
Date: 11 Oct 2002 18:25:48 -0700
Message-ID: <9da94cd1.0210111725.1a57c730@posting.google.com>


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 Fri Oct 11 2002 - 20:25:48 CDT

Original text of this message

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