Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!cyclone2.usenetserver.com!news.webusenet.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!fu-berlin.de!uni-berlin.de!fw.market-maker.DE!not-for-mail
From: "Matthias Rogel" <m.rogel@market-maker.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: update a vie
Date: Thu, 10 Oct 2002 08:23:07 +0200
Lines: 35
Message-ID: <ao36ck$iqanc$1@ID-86071.news.dfncis.de>
References: <ao2s5k$2k4i$1@mail.cn99.com> <ao2seo$2kff$1@mail.cn99.com> <941aqusg3semo9fmee6crctcmbdae7o7e0@4ax.com>
NNTP-Posting-Host: fw.market-maker.de (194.77.116.121)
X-Trace: fu-berlin.de 1034230996 19737324 194.77.116.121 (16 [86071])
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Xref: newsfeed1.easynews.com comp.databases.oracle.server:163690
X-Received-Date: Wed, 09 Oct 2002 23:23:11 MST (news.easynews.com)

what about UNION ALL - views ?
they should be updateable, or ?
now, iim have U teachers which are students?


"Sybrand Bakker" <gooiditweg@sybrandb.demon.nl> schrieb im Newsbeitrag
news:941aqusg3semo9fmee6crctcmbdae7o7e0@4ax.com...
> On Thu, 10 Oct 2002 11:33:45 +0800, "iim" <lianghs@163.net> wrote:
>
> >sorry
> >
> >my view is
> >
> >CREATE FORCE VIEW
> > users ( id, name, password, group_id )
> >>
> >>
> >
>
>
> The documentation would have told you UNION views are not updatable
> (which is logical, as Oracle can't decide from which table a record
> comes)
> If you are running 8i or higher (you don't mention a version) you can
> try instead of triggers. Please consult your documentation for further
> details.
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address