Oracle用表创建另外一张表

1、create TABLE Emp_bak as SELECT * FROM emp;

2、create TABLE Emp_bak as SELECT * FROM emp WHERE 1=2;
3、create table Emp_bak(id,name) as select empno,ename from emp;

4、用另一张表查询的数据批量插入到一张表中
INSERT INTO kkk(myid,myname,mydept) select empno, empname,deptno from emp;