Re: Boy... do I need some help with this one REPOSTED
From: David Nicodemus <davidn_at_bedford.progress.com>
Date: 1996/03/12
Message-ID: <DAVIDN.96Mar12142337_at_sthelene.bedford.progress.com>#1/1
Date: 1996/03/12
Message-ID: <DAVIDN.96Mar12142337_at_sthelene.bedford.progress.com>#1/1
>
> Oracle 7.3 handles update and deletes with views. It was release early
> last week.
>
> pierre.hansen_at_ey.com
Is there still a limit on updating views that are joins of more than one table ?
For example:
CREATE VIEW foo AS SELECT T0.name,T1.cust_num
FROM customer T0,order T1 WHERE T0.cust_num = T1.cust_num ;
UPDATE foo SET cust_num = 1
WHERE cust_num = 1 ;
Received on Tue Mar 12 1996 - 00:00:00 CET