Shell Programming and Scripting

How to execute a query which is stored in a variable.
Say for example :

v_source_query=”select count(*) from emp”
v_source_value=`sqlplus -S "$DATABASE_LOGIN" << EOF | tr '\n' ' '

set feed off
set pagesize 0
set head off
set linesize 2000

$v_source_query (I want to execute the query here)

EOF
`

echo $v_source_value

Any help is appreciated.

Trupti.

variables are case sensitive. Remove | tr '\n' ' '.
Rest is ok.

Code:

v_source_query=”select count(*) from emp”
v_source_value=`sqlplus -S "$DATABASE_LOGIN" << EOF 

set feed off
set pagesize 0
set head off
set linesize 2000

$v_source_query
EOF
`

echo $v_source_value

Well, thanks.
It is small v, may be it changed while copy pasting or something. Sorry about that.
But it is not working.

This is the error I get:

Syntax error at line 2 : `;' unexpected

Add semicolon

Code:

v_source_query=”select count(*) from emp;”

Did you do any modification to your script?

Okay, this is the actual program.
The column source_query from the table source has the query “select count(*) from emp;”

v_source_query=`sqlplus -S "$DATABASE_LOGIN" << EOF

set feed off
set pagesize 0
set head off
set linesize 2000
select source_query from source where source_id = $1;

EOF
`
echo $v_source_query

v_source_value=`sqlplus -S "$DATABASE_LOGIN" << EOF

set feed off
set pagesize 0
set head off
set linesize 2000

$v_source_query;

EOF
`
echo $v_source_value

try this

Code:

v_source_query="select source_query from source where source_id = $1;"

echo $v_source_query

v_source_value=`sqlplus -S "$DATABASE_LOGIN" << EOF

set feed off
set pagesize 0
set head off
set linesize 2000

$v_source_query;

EOF
`
echo $v_source_value

Okay i tried your example

It throws an error:

SP2-0223: No lines in SQL buffer.