Re: update two oracle tables with single SQL Query?

Mahesh schrieb am 16.04.2007 in
<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

Without knowing what to do it is difficult to give you an useful answer. If you write a view over both tables and some instead of- triggers for that view you can fill the view and in this case both tables within 1 query.
If not so you can only update 1 table with 1 statement.

AM

-- 
wenn email, dann AndreasMosmann <bei> web <punkt> de