Shell Programming and Scripting

I'm running a select statmenet from shell script, sometimes the result for the select is no rows selected. my question is, can I find a command in the shell asking about the result of the select and if the result is no data found print any msg I want instead of just writting no rows selected.
Thanks in advance

assuming your current script is something like

....
sqlplus $user/$password@$instance << EOF
Select * from table;
EOF
....

instead you can capture the output of sql in a shell variable and grep for "no rows" something like....

result=`sqlplus $user/$password@$instance << EOF
Select * from table;
EOF`

cnt=`echo $result | grep -c "no rows"`
if [ $cnt -gt 0 ] then;
echo "My custome message goes here"
fi

Hope it helps.

Rishi

Thanks for ur reply, your suggestion is very helpful but faced a problem with passing the parameter for the sql statment iwhen I run it in this way
this is how I run it
result=`sqlplus user/$password@$instance << EOF
echo "28/$rep_month/$rep_year"
@dwh_esc_act_dd_counts.sql
EOF`

I need to pass this value 28/$rep_month/$rep_year to the script dwh_esc_act_dd_counts.sql , but it's not working in this way .
any suggestions please !!

Thanks

The problem is the echo-command. You use a "here-document" (the "<<EOF ... EOF"-construct) and it isn't necessary to "echo" anything therein. Just use your variables and everything should be file:

Code:

typeset MyVar1="foo"
typeset MyVar2="bar"

cat <<EOF
This is MyVar1: $MyVar1
This is MyVar2: $MyVar2
EOF

You see there is no need to echo anything, the variables are being expanded (replaced with their content) by the shell automatically.

bakunin