Re: How to update 2 joinable tables in one satement ?

The question was to update two tables, not insert into them.

Don't feel badly. I misread things often enough myself.

Daniel Morgan

PUI wrote:

> Under Oracle 9i, you can use multi-table insert clause. See Oracle 9i SQL
> reference documentation.
>
> PIQ
>
> "Shamil Valeev" <valeevsh_at_mail.ru> a écrit dans le message de news:
> a9iuo1$j3n$1_at_news.nsk.su...
> > Hi Robert,
> >
> > I think it would be possible to create VIEW which join these tables.
> > Then create trigger with clause "instead of update".
> > In this trigger you may update both of the tables.
> > I have never tried to do this but I think it works.
> >
> >
Received on Wed Apr 17 2002 - 10:00:14 CDT