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: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: 1998/02/18
Message-ID: <34EB2EBC.57C104FC@ubs.com>#1/1

Robert Augustyn wrote:
>
> Hi,
> I am trying to update a view and I am getting errors
> saying that I can not modify more then one base table through the view
> Any solutions
> thanks in advance
> robert

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)

rgds
eugen Received on Wed Feb 18 1998 - 00:00:00 CST

Original text of this message

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