temhem
November 10, 2009, 2:55am
1
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
Thanx so much.
panyam
November 10, 2009, 3:42am
2
Something like this :
TES>ee=`sqlplus -s "username/passwd@sid" << EOF
> set -- options as needed
> select i from aa
> /
> EOF`
TES>echo $ee
bittoo
November 10, 2009, 3:53am
3
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