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
Case Study
3 weeks ago
No comments:
Post a Comment