Re: Simple trigger question

Kurt wrote:

> I'm real rusty with triggers..and I need one fairly quickly, so I
> would really appreaciate a bit of help.
>
> All I need to do:
>
> Upon insert or update of a row in a table, I need to check the value
> of one of the columns, and if it equals a certain value, then update
> one of the other columns and 'force' it to a certain value regardless
> of it's value in the insert the statement just issued. (the statement
> will provide a value for that column, but I need to make sure it gets
> forced to a particular value)
>
> This is a temporary fix for an application bug.
>
> Hope that makes sense,
>
> Thanks!

I've got a great idea ... go to http://tahiti.oracle.com and look up "TRIGGER". Another great idea ...

SELECT table_name, trigger_name
FROM all_triggers;

... then ...

SELECT trigger_body
FROM all_triggers
WHERE table_name = <table_name>
AND trigger_name = <trigger_name>;

I understand you may be rusty but I'm not going to do your work for you unless you pay my bill rate.
Put in some effort and I, and likely others, will jump in to help you if you have a problem.

Daniel Morgan Received on Fri Jan 10 2003 - 23:19:46 CST