Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Cascade Update Trigger Problems

Re: Cascade Update Trigger Problems

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Mon, 07 Aug 2006 20:54:41 +0200
Message-ID: <eb878c$6mt$1@news4.zwoll1.ov.home.nl>


dleenhouts_at_gmail.com schreef:
> Does anyone know how to use a trigger to update a table (& all child
> tables) so that an existing pk is updated to another existing pk. For
> instance, merging records so that:
>
> Key CompanyName
> 1 GE
> 2 General Electric
> 3 general electric
> 4 G.E.
>
> All become one single record. I would even be satisfied by assigning
> all 4 of these into a 5th record as long as all related records are
> attached. These also have a number of child records associated with
> them as well (orders, employees, etc).
>
> Thanks
>

What have you engineered so far?

What bothers me is "an existing pk is updated ..." Primary Keys are not meant to be updated (let the discussions begin!), not in 99.9% of all systems, anyway.

And based on WHAT should the records be merged? GE is not the same as general electric, you know.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
Received on Mon Aug 07 2006 - 13:54:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US