Oracle 表结构及数据复制

WBOY

Release： 2016-06-07 14:57:11

Original

1153 people have browsed it

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

Copy after login

Related labels：

oracle s content copy data structure detailed

source：php.cn

Previous article：ETL调度系统 Next article：SQL xp_cmdshell

Statement of this Website

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn