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;