unix-sql

#!/bin/ksh
cmd="echo \"conn <user>/<pasword>@<tnsping>\"";
cmd="${cmd} | sqlplus \/nolog"
out_line=`eval ${cmd}` ;


#echo "$out_line"
#echo "`echo $out_line|grep -i connected|wc -l`"


if [ `echo $out_line|grep -i connected|wc -l`  = 1 ]; then
echo "Success"
else
echo "Fail"
fi