Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: update two oracle tables with single SQL Query?
On Apr 16, 12:49 pm, "Mahesh" <registered.h..._at_gmail.com> wrote:
> Hi All
> I just need to know is it possibel to update two different tables in a
> single SQL Query??
>
> Thanks in advance
> Maheshkumar
You can update inline views
update (select empno, ename, deptno, dname
from emp, dept where emp.deptno = dept.deptno)set
etc.
-- Sybrand Bakker Senior Oracle DBAReceived on Mon Apr 16 2007 - 06:17:10 CDT