I have just updated many rows in a particular table using the following syntax:-
update table set effective_date = sysdate+1
This was then followed by a commit.
However this does not seem to have worked the dates have remained what they were previously. However there is another column that gets updated when any records are updated and this has been changed to todays date.
Can any one shed anylight why this would happen.
02-07-2002, 05:43 AM
strange behaviour, have you checked if there is a trigegr on this table ???
select trigger_name, trigger_body
where table_name = 'YOUR_TABLE';