Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed-west.nntpserver.com!hub1.meganetnews.com!nntpserver.com!telocity-west!TELOCITY!sn-xit-03!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: Sybrand Bakker <gooiditweg@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: update a vie
Date: Thu, 10 Oct 2002 18:51:47 +0200
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <subbquk8rracppfajh5lgnl0pd777vai78@4ax.com>
Reply-To: postbus@sybrandb.demon.nl
References: <ao2s5k$2k4i$1@mail.cn99.com> <ao2seo$2kff$1@mail.cn99.com> <941aqusg3semo9fmee6crctcmbdae7o7e0@4ax.com> <ao36ck$iqanc$1@ID-86071.news.dfncis.de>
X-Newsreader: Forte Agent 1.92/32.572
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@supernews.com
Lines: 17
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163745
X-Received-Date: Thu, 10 Oct 2002 09:50:42 MST (news.easynews.com)

On Thu, 10 Oct 2002 08:23:07 +0200, "Matthias Rogel"
<m.rogel@market-maker.de> wrote:

>what about UNION ALL - views ?
>they should be updateable, or ?

Why? Oracle won't be able to distinguish between the 2 tables
involved.



Regards


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address