hi,

In an UPDATE operation I want to update even the field(s) that are specified in the WHERE clause.

Update statement, i.e. for ex.

Update DEMO set AA=‘100’, BB=‘200’,CC=‘300’ where AA=‘50’ and DD=‘50’;

After executing UPDATE script, fields BB & CC will get updated but field AA is not getting updated.

Any tips are welcome.

Hi Anil,

I have tried the above and its working fine for me…Is there any CONSTRAINTS or RULES for AA field??

Cheers,
Thota