Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news-out.visi.com!petbe.visi.com!news.tele.dk!news.tele.dk!small.news.tele.dk!uninett.no!feed.news.nacamar.de!bnewspeer00.bru.ops.eu.uu.net!emea.uu.net!newsfeed.siemens.de!news.mch.sbs.de!not-for-mail
From: "Su Man" <subu501@yahoo.com>
Newsgroups: comp.databases.oracle.misc
Subject: Re: Changing Foreign Key Entry
Date: Fri, 4 Apr 2003 15:11:19 +0530
Organization: ---
Lines: 37
Message-ID: <b6jjrr$4d0$1@news.mch.sbs.de>
References: <b6huta$5jso8$1@ID-121870.news.dfncis.de> <3E8CA783.DA5EAABF@exxesolutions.com>
NNTP-Posting-Host: 132.186.195.199
X-Trace: news.mch.sbs.de 1049449148 4512 132.186.195.199 (4 Apr 2003 09:39:08 GMT)
X-Complaints-To: abuse@siemens.de
NNTP-Posting-Date: Fri, 4 Apr 2003 09:39:08 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:95787
X-Received-Date: Fri, 04 Apr 2003 02:38:50 MST (news.easynews.com)

One Question :

Don't we have something like ON UPDATE CASCADE ( similar to ON DELETE
CASCADE) ???

"DA Morgan" <damorgan@exxesolutions.com> wrote in message
news:3E8CA783.DA5EAABF@exxesolutions.com...
> Nicolas Bronke wrote:
>
> > In a database there are existing a foreign key. The fieldtype is
Varchar2.
> > Now one entry of the foereign key shall be changed, because of a
misspelling
> > in the reference table and therefore also in the detail tables.
> >
> > I thought I have to disable the foreign key, change the value and enable
the
> > foreign key again.
> >
> > Now someone told me that there is also another way via a trigger on the
> > reference table. Is that true?
> >
> > Regards
> > Nicolas
>
> Add the correct value to the lookup table
> update the child table
> delete the incorrect value.
>
> This is not a proper use of a trigger or any other complicated way to
perform a
> simple update.
>
> Daniel Morgan
>