Re: Trick to update 2 tables in the same view?

the quick fix is to use a separate update statement against each table.

the "trick" would be creating a view which is "key-preserved", which is only only possible (AFAIK) if the tables include the same primary key columns, and the view includes an equi-join on the primary keys.

HTH "Tony" <micronet_at_chello.nl> wrote in message news:94ovna$5jv$1_at_news1.xs4all.nl...
> Is there a trick to update 2 tables in the same view ?
>
> Without triggering the
> "ORA-01779: cannot modify a column which maps to a non key-preserved
 table"
>
> Something in PL/SQL perhaps?
>
> Thanx Tony
>
>
>
>
Received on Sat Jan 27 2001 - 15:17:34 CST