Our developers are working on a large project that is going to require a lot of scripts to convert data and due to an error in one of the scripts one of our tables was fubar. So the question came up - is there a way in a trigger or other method to trap UPDATE statements that do not have a WHERE clause? I'm searching for this now but wanted to poll the list at the same time. Off the top of my head I couldn't come up with anything. Thanks! Chris -- //www.freelists.org/webpage/oracle-l