清空表 oracle --truncatetruncate table gh_qytc_ls;//从一个表插入到另外一个表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;