what about UNION ALL - views ?
they should be updateable, or ?
now, iim have U teachers which are students?
"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> schrieb im Newsbeitrag
news:941aqusg3semo9fmee6crctcmbdae7o7e0_at_4ax.com...
> On Thu, 10 Oct 2002 11:33:45 +0800, "iim" <lianghs_at_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
Received on Thu Oct 10 2002 - 01:23:07 CDT
