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