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: Update view

Re: Update view

From: SC <s_c_99_at_hotmail.com>
Date: Fri, 31 Mar 2000 10:49:32 +0100
Message-ID: <38E474AC.E54901D@hotmail.com>


Maggie,
I think you can't update or insert records into a view if it is created using two tables and joins. ("create view .... with check option" can not be used).

Maggie wrote:
>
> When I try to update a view, I get an error:
>
> CREATE TABLE t1
> (
> c1 NUMBER,
> c2 NUMBER
> )
>
> CREATE TABLE t2
> (
> c1 NUMBER,
> c2 NUMBER
> )
>
> create view tt as
> select t1.c1, t1.c2, t2.c2 "c4"
> from t1, t2
> where t1.c1 = t2.c1
>
> update tt
> set c4 = c2
> and I get " ORA-00904: invalid column name "
>
> Please tell me why?
Received on Fri Mar 31 2000 - 03:49:32 CST

Original text of this message

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