Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can you update more then one table through the view?
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