Re: 10g: Update a Join View

And *WHY* denormalise the deptname to the emp table?

That's just asking for trouble.

If you *MUST* do it. (which you mustn't), atleast add a foreign key.

klabu wrote:
> 10gXE
> I get error "ORA-01776: cannot modify more than one base table through a
> join view"
> while testing the SQL below...
> Is there a way to get around this ?
>
> thanks
>
> -------------------------------------------------------------------------
> scott_at_XE> alter table emp add (dname varchar2(14));
>
> Table altered.
>
> scott_at_XE> update emp set dname = 'COKE';
>
> 14 rows updated.
>
> scott_at_XE> commit;
>
> Commit complete.
>
> scott_at_XE>
> 1 UPDATE
> 2 (SELECT me.dname medname, md.dname mddname
> 3 FROM
> 4 emp me, dept md
> 5 WHERE me.deptno = md.deptno
> AND empno = 7369 )
> 6* SET medname = 'BEER', mddname = 'WINE'
> *
> ERROR at line 6:
> ORA-01776: cannot modify more than one base table through a join view
Received on Sun Oct 08 2006 - 05:58:21 CDT