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;
中国足彩网信息请查看IT技术专栏