rt_update_select.md

Show ResultSet Types：update_select

oracle

UPDATE employees SET salary = (SELECT salary * 1.1 FROM employees WHERE department_id = 80) WHERE department_id = 80; 
create view eview as select * from employees;

显示前：

显示后：