Re: Creating an view that updates related tables

From: <derf23456_at_my-deja.com>
Date: Fri, 26 Jan 2001 13:57:22 GMT
Message-ID: <94rvnu$lni$1@nnrp1.deja.com>

In article <94psu9$gp6$1_at_news3.cadvision.com>, "Jeff Boyer" <jdboyer@(remove)icomproductions.ca> wrote:
> 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?
>
>

From Oracle's "Oracle7 Server SQL Reference" Rel 7.3: "You cannot insert rows into a view if the view's defining query contains one of the following constructs: join , set operator, GROUP BY clause, group function, DISTINCT operator".

So, if you're using <= 7.3, you're outta luck.

Sent via Deja.com
http://www.deja.com/ Received on Fri Jan 26 2001 - 07:57:22 CST