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

From: Andrew Pahomov <Pahomov_at_validio.com.ua>
Date: Thu, 25 Jan 2001 12:59:41 +0200
Message-ID: <3a70071d$1@miik2-ilt.ilt.kharkov.ua>

Only use INSTEADOF trigger on view

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 Thu Jan 25 2001 - 04:59:41 CST

This message: [ Message body ]
Next message: Brian Peasland: "Re: Is there a limit of rows in V$ARCHIVED_LOG"
Previous message: Valery Yourinsky: "Re: Trick to update 2 tables in the same view?"
Maybe in reply to: Valery Yourinsky: "Re: Trick to update 2 tables in the same view?"
Next in thread: John Russell: "Re: Trick to update 2 tables in the same view?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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