1.批量增加的定义语法insert into (table表名) selectquery
-- 批量增加
-- insert into DEPT(DEPTNO,DNAME,LOC)(SELECT (DEPTNO+1),DNAME,LOC from DEPT);
2.批量修改的定义语法update (table表名) set (column列名)= selectquery
-- 批量修改
update DEPT set DNAME=(select dname from dept where deptno=21) where deptno in(11,21,31,41);