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://blog.itpub.net/27042095/viewspace-748091/