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

Oracle For Unix

export ORACLE_HOME=/opt/oracle/product/10.2.0
export NLS_LANG=AMERICAN_AMERICA.UTF8
export PATH=$ORACLE_HOME/bin:$PATH

sqlplus -S -M "HTML ON TABLE 'BORDER="2"'" user/passwd@dbname @c:\a.txt > c:\a.html
set longchunksize 13000
set long 13000
set linesize 15000
select long_desc from content where rownum <10 and long_desc is not null and rownum < 10;
exit