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: update two oracle tables with single SQL Query?

Re: update two oracle tables with single SQL Query?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 16 Apr 2007 17:33:17 +0200
Message-ID: <4623973c$0$3285$426a34cc@news.free.fr> 






"Mahesh" <registered.here_at_gmail.com> a écrit dans le message de news: 1176720582.507443.230440_at_w1g2000hsg.googlegroups.com...


| Hi All

| I just need to know is it possibel to update two different tables in a

| single SQL Query??

|

| Thanks in advance

| Maheshkumar

|




No, you can't unless you put your 2 tables in a view
and write an "instead of" trigger on this one.



Regards


Michel Cadot
Received on Mon Apr 16 2007 - 10:33:17 CDT












Original text of this message













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