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

Home -> Community -> Usenet -> c.d.o.server -> Re: Foreign keys in Oracle

Re: Foreign keys in Oracle

From: William Robertson <williamr2019_at_googlemail.com>
Date: 15 Apr 2007 00:52:40 -0700
Message-ID: <1176623560.200961.151500@q75g2000hsh.googlegroups.com>


On Apr 15, 1:39 am, "valigula" <valig..._at_gmail.com> wrote:
> Hi ;
> I want to load some data froma table (A) into several others (B,
> C ...), the problem is those others may not contain the data. I would
> control this with a FK.
> My question is: it is posible to program a stored procedured so when
> then FK is boken it would load the data into (B, C .. etc .. )??
>
> thanks in advance
>
> A.

Sounds like you might be able to achieve this with a multitable insert, using "INSERT FIRST" and multiple WHEN clauses, driven off an outer join of the source and target tables. Received on Sun Apr 15 2007 - 02:52:40 CDT

Original text of this message

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