Oracle: What's new in UPDATE Statement

Update the results of a SELECT statement

UPDATE (SELECT Statement)
SET column_name = value
WHERE column_name condition value;

UPDATE ( SELECT FROM emp WHERE dept =10)
SET sal = sal + (sal * 10/100)
WHERE grade = 'A';