====>a.sql
spool on
set pages 50000
set lines 200
set trims on
set colsep ','
set heading off
set termout off
set feedback off
SPOOL t2.csv
select /*+PARALLEL(20)*/
BROAD_RATE_ATTR_ID,
'20230707','duanhw'
from T_DIM_BROAD_RATE;
SPOOL OFF
exit
====>
my $sql_script = 'a.sql';
system("sqlplus user/passwd\@DB3 \@${sql_script} \\ ");
文章来源地址https://www.toymoban.com/news/detail-529222.html
文章来源:https://www.toymoban.com/news/detail-529222.html
到了这里,关于Perl 通过sqlplus 执行Spool语句的文章就介绍完了。如果您还想了解更多内容,请在右上角搜索TOY模板网以前的文章或继续浏览下面的相关文章,希望大家以后多多支持TOY模板网!