| 范文 |
Oracle数据库表结构及数据的复制，具体代码如下：
--只复制表结构
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; |