Oracle快速复制表
时间：2021-07-01 10:21:17
帮助过：5人阅读
//从一个表插入到另外一个表
insert into gh_qytc_ls SELECT *
FROM gh_qytc tc;
快速copy一张表数据到另外一张表
1
、创建一个临时表，字段和要用的表相同
create table gh_qyghgx_temp as select * from gh_qyghgx where qybm=‘F227‘
;
2
、查询临时表是否创建成功
select *
from gh_qyghgx_temp;
3
、删除临时表的那条记录
truncate table gh_qyghgx_temp;
4
、把要备份的表的数据放入临时表
insert into gh_qyghgx_temp select *
from gh_qyghgx
5
、查询是否插入成功
select count(*) from gh_qyghgx_temp;
Oracle快速复制表
标签：select trunc span table HERE 记录 from ble oracle
