sql and script

Shell Programming and Scripting
1

hi,

I have a query :

select max(filed1) from tab1

I want to run this query in a script and store the value into a variable called max_fld_no

The query returns somethig like this

  \(max\)

 910117

1 row(s) retrieved.

i want o store the value 910117 to max_fld_no
can somebody help me

TIA
JS

2

Result=`sqlplus -s $DB_USER/$DB_PWD@$DB_STRING <<END
set echo off
set head off
select max(910117) from dual;
exit;
END`

echo $Result