This content has been marked as final. Show 3 replies
dont think so1 person found this helpful
you can insert into mutliple tables using insert all and insert first
and you can do multiple operations to the same table using merge
but I don't think you can do multiple updates to different tables in one shot.
No , You can update single update statement single table.1 person found this helpful
But you can update multiple columns
update table1 set col1='col1 value', col2='col2 value'
you can use this
read this please : http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10007.htm
UPDATE t1 t1_alias SET (table_name, tablespace_name) = ( SELECT table_name, tablespace_name FROM t2 t2_alias WHERE t1_alias.table_name = t2_alias.table_name);
Edited by: Mahir M. Quluzade on May 16, 2011 6:32 PM
1 person found this helpful
Is it possible to update multible tables in a single query using join queries.The error message speaks for itself:
SQL> update (select ename, dname from emp e, dept d where e.deptno = d.deptno and empno = 7788) set ename = 'X', dname = 'Y' / Error at line 1 ORA-01776: cannot modify more than one base table through a join view