select count(*) in sqlplus into variable unix shell

struggle · December 10, 2007, 9:23am

Need to select count(*) from table to check for zero result in unix script

jim_mcnamara · December 10, 2007, 9:53am

One way:

#!/bin/ksh
myvariable=$( 
echo "set feed off
set pages 0
select count(*) from table;
exit
"  | sqlplus -s username/password@oracle_instance
)
echo "found count = $myvariable"

mervinboyz · March 26, 2008, 11:12pm

jim mcnamara:

One way:

#!/bin/ksh
myvariable=$( 
echo "set feed off
set pages 0
select count(*) from table;
exit
"  | sqlplus -s username/password@oracle_instance
)
echo "found count = $myvariable"

Hi, I tried using your codes, but I keep getting this error: