Development question - Trigger to disallow UPDATE without WHERE clause?

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


--
http://www.freelists.org/webpage/oracle-l


Other related posts: