Search Results

It is printing the query stored in the database.
But i dont want it to print the query, i want it to execute the query and print the output.

Hey thanks, i am being such a pest, but i am so new to Shell scripting. Just a week old.

Your example is simply printing the query on the screen, i want it to execute and give me the output.
...

Okay i tried your example

It throws an error:

SP2-0223: No lines in SQL buffer.

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

...

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

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' ' '

...