Shell Programming and Scripting

Hello abdul,

you have used ' instead of ` in the above code.
look for the above symbol above tab button in keyboard .. :-)

dude,

why not just redirect the output to a file first so you can analyze what is wrong with the output. since from experience when you perform sqlplus there are some garbage which you do not need. then start from there.

Code:

sqlplus -s apps/apps <<endsql > output.txt
set feedback off
set heading off
select 6 from dual;
exit;
endsql

or

Code:

sqlplus -s apps/apps <<endsql
set feedback off
set heading off
select 6 from dual;
spool output.txt;
r;
exit;
endsql

also from experience sometimes when you put the query into script it will give you no output. so try to spool the output then you can start from there or either way try them both then filter out the garbage so you can have what you want. a log file is also good for troubleshooting but if you do not like you can just redirect the result to a variable.

hope this helps.

$Test_Var=
`sqlplus -s $USERNAME/$PASSWD@$DATABASE <<START
set echo off;
set head off;
select 10 from dual;
exit;
START | tr -d " " `

Output
$echo $Test_Var
10
$

Hi Team,

I have tried code to get the value from oracle. but it is not working. The error shows invalid identifier. but if i execute same query in oracle SQL*PLUS it is working fine.

v_test=$(sqlplus -s apps/apps <<END
set feedback off;
set heading off;
select c_code from tab_code where c_name = 'NAM';
EXIT;
END)