Oracle 常用语句

复制表
create table 创建的表面 as select * from 原始表 where 1=2

刷新序列号
select 表seq.nextval name from dual

复制表数据
insert into sam_experiment(sam_experimentid, description, assetnum)
select a.sam_experimentid,a.description,a.assetnum from sam_experiment_test a
where a.sam_experimentid>10000

移库
insert into jobcard select * from jobcard@dblink18

备份表
create table SAM_OVERHAULRESUME_back as select * from SAM_OVERHAULRESUME

清除表
truncate table tablename

替换换行符
update jobcardline set wksafespec=replace(wksafespec,’/n’,chr(13))