Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Creating an view that updates related tables
Take a look at the 'Instead Of' trigger available in 8i (maybe 8.0.6?).
Jeff Boyer <jdboyer@(remove)icomproductions.ca> wrote in message
news:94psu9$gp6$1_at_news3.cadvision.com...
> Hello,
>
> Can someone tell me how to create a view of two related tables so I can
> Insert data into these tables at once. I have tried to make a view that
> joins two related tables but since I am Insetring into this view, I would
> assume that I have to have the Primary key from the parent table and the
> forigen key from the child table so I can insert data into each field.
> Oracle is telling me I have dupliacte coumns even though I am defining
them
> as table1.field and table2.field. Can anyone help?
>
>
>
Received on Thu Jan 25 2001 - 17:52:45 CST