一．創(chuàng)建空表.

sql> create table test_dept as select * from scott.dept where rownum>1000;


二．從其它表按字段插入指定數據

sql> insert into test_dept(deptno, dname)  select deptno, dname from scott.dept;