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: Shamil Valeev <valeevsh_at_mail.ru>
Date: Wed, 17 Apr 2002 11:47:50 +0700
Message-ID: <a9iuo1$j3n$1@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 Tue Apr 16 2002 - 23:47:50 CDT












Original text of this message













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