Assign result to variable

Hi friends,

firstly, i can run following expression and i took 100 value.

sqlplus -s username/password@TTTEST @umt.sql

umt.sql exists "select t.deger from parametre t where t.id=30".
result of this query =100

i need to assign this value(100) to variable(for example x variable).
How can i do this?

i tried x=select t.deger from parametre t where t.id=30 but i cant take it :frowning:

Thanx so much.

Something like this :

TES>ee=`sqlplus -s "username/passwd@sid" << EOF
> set  -- options as needed
> select i from aa
> /
> EOF`

TES>echo $ee

VAR=`sqlplus -s username/passwd@sid << END
set heading off pagesize 0 verify off feedback off echo off
select t.deger from parametre t where t.id=30;
exit;
END`
echo $VAR