-
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.
Thanks
-
strange behaviour, have you checked if there is a trigegr on this table ???
select trigger_name, trigger_body
from all_triggers
where table_name = 'YOUR_TABLE';
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|