加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 大数据 > 正文

Perl自动格式输出select 结果

发布时间:2020-12-15 23:49:09 所属栏目:大数据 来源:网络整理
导读:#!/usr/bin/perl use strict;use DBI;my $dbName = 'orcl'; my $dbUser = 'test'; my $dbUserPass = 'test'; my $dbh = DBI-connect("dbi:Oracle:$dbName",$dbUser,$dbUserPass) or die "can't connect to database ";if ($#ARGV 0){ print "请输入一个参数
#!/usr/bin/perl   
use strict;
use DBI;
my $dbName = 'orcl';  
my $dbUser = 'test';  
my $dbUserPass = 'test';  
my $dbh = DBI->connect("dbi:Oracle:$dbName",$dbUser,$dbUserPass) or die "can't connect to database ";
if ($#ARGV <0){
   print "请输入一个参数n";
  exit(-1);
}
my $var=$ARGV[0];
my $sql = $var;

if ($var =~ /selects+(.+)s+froms+.*/i){ $a = $1};
my @arr = (split /,/,"$a");
foreach (@arr){
print "$_"." ";
}
my $sth = $dbh->prepare($sql); 
$sth->execute();  
while (my  @arr = $sth->fetchrow_array()){
print "n@arrn";
}
sh-3.2$ perl a5.pl "SELECT sid,serial#,module from v$session" | more
sid serial#  module 
1626 521 

1627 1421 perl@jhoa (TNS V1-V3)

1630 3 

1634 2 

1635 1442 SQL*Plus

1640 9 

1645 1 

1646 1 

1647 1 

1648 1 

1649 1 

1650 1 

1651 1 

1652 1 

1653 1 

1654 1 

1655 1 

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读