Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Foreign keys in Oracle
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
![]() |
![]() |