Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!lnewsoutpeer01.lnd.ops.eu.uu.net!bnewsinpeer01.bru.ops.eu.uu.net!bnewspost00.bru.ops.eu.uu.net!emea.uu.net!not-for-mail
From: "Niall Litchfield" <niall.litchfield@dial.pipex.com>
Newsgroups: comp.databases.oracle.server
References: <0y9Md.98189$Qb.44072@edtnps89>
Subject: Re: need trigger suggestions (works but is SLOW)
Date: Wed, 2 Feb 2005 21:10:42 -0000
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
Lines: 18
Message-ID: <420141c0$0$16583$cc9e4d1f@news-text.dial.pipex.com>
NNTP-Posting-Host: 81-178-89-188.dsl.pipex.com
X-Trace: 1107378624 news-text.dial.pipex.com 16583 81.178.89.188:2361
X-Complaints-To: abuse@uk.uu.net
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:234838

"Glen S" <whoknows@no_spam.com> wrote in message 
news:0y9Md.98189$Qb.44072@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.com