SQL> select col1, col3 from t;
COL1 C
---------- -
1 Y
$ cat test3.sh
#!/bin/ksh
RET1=` sqlplus -s / << EOF
set echo off head off feed off verify off term off
select col3 from t
where col1=1;
EOF
`
echo "RET1 >>>>"$RET1"<<<<"
if [[ $RET1 == 'Y' ]]; then
echo "Yes"
else
echo "No"
fi
RET2=` sqlplus -s / << EOF
set echo off head off feed off verify off term off
set pagesize 0
select col3 from t
where col1=1;
EOF
`
echo "RET2 >>>>"$RET2"<<<<"
if [[ $RET2 == 'Y' ]]; then
echo "Yes"
else
echo "No"
fi
$ ./test3.sh
RET1 >>>> Y<<<<
No
RET2 >>>>Y<<<<
Yes
Tuesday, August 03, 2010
Effect of a SQL* Plus environment variable: set pagesize 0
Last night, I troubleshooted a ksh shell script, in which a variable is assigned a value that is returned from SQL* Plus commands. I found that without 'set pagesize 0', the value returned had an undesirable leading space. Below is a test case that demonstrate this effect.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment