【Oracle】批量处理数据

1.向emp表，批量插入来自scott_emp表中部门号为20的员工信息

insert into emp(empno,ename,job,sal)
       select empno,ename,job,sal from scott.emp
       where deptno = 20;

2.复制表结构(将1=2改为1=1同时也复制数据)

-- 复制scott表结构
create table emp(empno,ename) as 
       select empno,ename from scott.emp where 1 = 2;