当前位置:Gxlcms > mysql > Oracle表结构及数据复制

Oracle表结构及数据复制

时间:2021-07-01 10:21:17 帮助过:10人阅读

无详细内容 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;

人气教程排行