Oracle 表结构及数据复制
- 作者: 三爪猫60212662
- 来源: 51数据库
- 2022-08-17
--只复制表结构 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;
推荐阅读
