1. 首页
  2. IT资讯

shell里调用sqlplus 使用不同linesize 对比表现

1、set linesize 200
#!/bin/bash
#Filename:del_arch1.sh
. /home/oracle/.bash_profile
res=`sqlplus -S / as sysdba <
set pagesize 0 feedback off linesize 200 echo off termout off trimspool on
col seq new_value v_seq
select name from v\$archived_log where rownum < 2;
EOF`
echo $res

[oracle@shanxi test]$ bash del_arch1.sh
/u01/arch/1_3_798157732.arch
上述表现正常。
2、set linesize 2

#!/bin/bash
# Filename:del_arch2.sh

. /home/oracle/.bash_profile
res=`sqlplus -S / as sysdba <
set pagesize 0 feedback off linesize 2 echo off termout off trimspool on
col seq new_value v_seq
select name from v\$archived_log where rownum < 2;
EOF`
echo $res
[oracle@shanxi test]$ bash del_arch2.sh
/u 01 /a rc h/ 1_ 3_ 79 81 57 73 2. ar ch
表现异常,中间多出好多空格,每2个字符被隔开。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27042095/viewspace-748091/,如需转载,请注明出处,否则将追究法律责任。

主题测试文章,只做测试使用。发布者:布吉卡,转转请注明出处:http://www.cxybcw.com/196105.html

联系我们

13687733322

在线咨询:点击这里给我发消息

邮件:1877088071@qq.com

工作时间:周一至周五,9:30-18:30,节假日休息

QR code