using subquery in the SET clause of UPDATE statement ...

... in the SET clause of UPDATE statement : update « Subquery « Oracle PL / SQL. ... SQL> select o.emp_no, o.salary, (select avg(i.salary) * 1.1 from employee i

www.java2s.com