Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can you update more then one table through the view?

Re: Can you update more then one table through the view?

From: Chuck Kincy <ckincy_at_pitc.com>
Date: 1998/02/19
Message-ID: <35057b96.490377738@enews.newsguy.com>#1/1

On Wed, 18 Feb 1998 19:55:56 +0100, Eugen Nyffeler <eugen.nyffeler_at_ubs.com> wrote:

>Prior version 7.3 a view could only be updated, when the relation view
>vs. table was 1:1.
>For 7.3 and higher it should be possible to update views based on more
>than 1 table (but i think there are some restrictions)

You can only cause an update of one table at a time. You're not at "liberty" to update more than one table or it'll barf with ORA-1776. Heh.

/cpk Received on Thu Feb 19 1998 - 00:00:00 CST

Original text of this message

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