Hello All:
I have a little shell script that checks for no row. Here is the sample:
++++++++++++++++++
I will like to hide the password "sunny123". I was wondering if anyone could help.
Thanks.
I have a little shell script that checks for no row. Here is the sample:
Code:
#!/bin/ksh
NAME=no rows selected
ORACLE_SID=mydtbase
export $ORACLE_SID
sqlplus -L userprod/sunny123@mydtbase <<!
@myscript.sql
exit
!
if (grep $NAME mydtbase.txt); then
echo
else
echo "There are rows in READY STATE on `hostname` "| mailx -s Subject $DBALIST
fi
exit
I will like to hide the password "sunny123". I was wondering if anyone could help.
Thanks.