Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to update 2 joinable tables in one satement ?

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

From: PUI <daouda.sow_at_netdealing.com>
Date: Wed, 17 Apr 2002 09:02:14 +0200
Message-ID: <a9j6l3$6ek$1@news2.isdnet.net> 





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 - 02:02:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US