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

Tony wrote:
>
> 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?
>

   Hi Tony,
   All correct.
   See USER_UPDATABLE_COLUMNS for your view.    

   Read

      Oracle 8i. Concepts
         Part IV. The Object-Relational DBMS
            10. Schema Objects
                Views
                   Updatable Join Views

Valery Yourinsky

-- 
Oracle8 Certified DBA