hi,
i need to use the output of select query.
the output i get using
"X=`sqlplus -s $var1/$var1<<eof
select port from table1;`
echo $X "

is

"port ----- 2000"
now i want to use only 2000 in my next command.
hw do i do it?

Use
SET HEADING OFF;

This statement should be immediately after you login to sql.


Ideally this is the way it has to look.

"X=`sqlplus -s $var1/$var1<<eof
SET HEADING OFF;
select port from table1;`
echo $X "


Let us know if this worked or not..

thanks a lot helper..
Actually i need two different ports from two different tables.
if i use the earlier script, echo $X shows two ports.
but the next netstat command uses only the first port.
hw can i use the result of echo $x ,say 2000 2001 in netstat command ,to chk whether they r up?

Use for loop and use the command netstat

"X=`sqlplus -s $var1/$var1<<eof
SET HEADING OFF;
select port from table1;`
echo $X "
for i in `echo $X`
do
netstat -i $X
done

hi helper,
thanks.
it worked but with a simple change.ie netstat -an|grep $i