1、批量插入数据
insert all
into copy_dept(deptno,dname) values('50','50')
into copy_dept(deptno,dname) values('60','60')
select 1 from dual;
2、批量删除数据
3、批量修改数据
update copy_dept set dname = decode(deptno,'50','修改了50','60','修改了60')
where deptno in('50','60');