print SQLPLUS <<ENDOFINPUT;
SET TIMING ON;
SET time ON;
SET ECHO ON;
SET LINESIZE 1000;
SET HEADING ON;
alter session enable parallel dml;
WHENEVER SQLERROR continue
delete from dss_ptemp.verify_result
where TABLE_NAME='$tablename';
COMMIT;
L;
WHENEVER SQLERROR EXIT SQL.SQLCODE
insert into dss_ptemp.verify_result
select
'${tablename}',
<#VerifyOritable_sql#>
From ${tablename};
;
L;
exit;
ENDOFINPUT
SET TIMING ON;
SET time ON;
SET ECHO ON;
SET LINESIZE 1000;
SET HEADING ON;
alter session enable parallel dml;
WHENEVER SQLERROR continue
delete from dss_ptemp.verify_result
where TABLE_NAME='$tablename';
COMMIT;
L;
WHENEVER SQLERROR EXIT SQL.SQLCODE
insert into dss_ptemp.verify_result
select
'${tablename}',
<#VerifyOritable_sql#>
From ${tablename};
;
L;
exit;
ENDOFINPUT
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货