Oracle 表结构及数据复制

无详细内容 Oracle SQL Developer --只复制表结构create table studentTemp as select * from student where 1=2;--条件为假 未得到数据--复制已有表数据到新表insert into studentTemp select * from student;insert into studentTemp(...) select ... from

Oracle SQL Developer

--只复制表结构
create table studentTemp as select * from student where 1=2;--条件为假 未得到数据

--复制已有表数据到新表
insert into studentTemp select * from student;

insert into studentTemp(...) select ... from student;


--复制表结构与数据
create table copyStudent as select * from student;


insert into copyStudent select * from student;