Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: need trigger suggestions (works but is SLOW)
"Glen S" <whoknows_at_no_spam.com> wrote in message
news:0y9Md.98189$Qb.44072_at_edtnps89...
>I created a trigger on an app that will update a column on a newly inserted
>row if another column's value(in the new row) matches some values in other
>tables.
I've spent approx 30s on this so may be wrong but doesn't this boil down to
check that col2 exists in col f in some other table - check constraints should do this.
-- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.comReceived on Wed Feb 02 2005 - 15:10:42 CST