Re: update row in a view

From: SKurosky <skurosky_at_aol.com>
Date: 20 Jan 2000 19:13:05 GMT
Message-ID: <20000120141305.09281.00000068@ng-cm1.aol.com>

>Hallo!
>
>I have a view like
>select t1.c1 t2.c1 from t1,t2 where t1.c2 = t2.c2.
>I can´t update rows in this view.
>What did i wrong?
>
>Any help would be great!
>
>Thomas Meiers
>
>
>
>
>
>

I don't think you can update a view with a join. Only single table views can be updated, I believe
Hth
Sandy Received on Thu Jan 20 2000 - 13:13:05 CST

This message: [ Message body ]
Next message: Novice: "Oracle Administration"
Previous message: SKurosky: "Re: ORA-04031: error ..how to solve this ??"
In reply to: Thomas Meiers: "update row in a view"
Next in thread: Keith Jamieson: "Re: update row in a view"
Reply: Keith Jamieson: "Re: update row in a view"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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