RE: Development question - Trigger to disallow UPDATE without WHERE clause?

http://www.orafaq.com/usenet/comp.databases.oracle.server/2005/01/13/0713.htm

Glad those comp.databases.oracle.server archives are found in various places.

+1 Tom Kyte (heh)

Chris Taylor
Sr. Oracle DBA
Ingram Barge Company
Nashville, TN 37205

"Quality is never an accident; it is always the result of intelligent effort." -- John Ruskin (English Writer 1819-1900)

CONFIDENTIALITY NOTICE: This e-mail and any attachments are confidential and may also be privileged. If you are not the named recipient, please notify the sender immediately and delete the contents of this message without disclosing the contents to anyone, using them for any purpose, or storing or copying the information on any medium.

-----Original Message-----
From: Phil Jones [mailto:phil_at_phillip.im] Sent: Friday, January 27, 2012 2:29 PM
To: Taylor, Chris David
Cc: oracle-l_at_freelists.org
Subject: Re: Development question - Trigger to disallow UPDATE without WHERE clause?

If v$sql gets populated before any records are actually processed (I imagine it is, but a quick test will verify) & the sql_id in v$session also gets populated after the query has been parsed but before any rows are processed you might be able to do it in a before update trigger that throws an exception. You'll need sys_context('USERENV','SID') to join with the v$ tables.

To be honest, you'd be better off using a cluebat on the devs :)

Phil

On 27 Jan 2012, at 20:13, "Taylor, Chris David" <ChrisDavid.Taylor_at_ingrambarge.com> wrote:

> 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
>
>

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