Assign output of sql query to a variable in unix

Question

I am using the following simple UNIX script to assign the output to a variable.

count=`sqlplus -s ${DB_USER}/${DB_PASS}@${DB_INST} << END
        SELECT COUNT(column_name) from table_name;
END`

echo $count

But I am getting the following error on executing:

SP2-0042: unknown command "END" - rest of line ignored.

count=`sqlplus -s ${DB_USER}/${DB_PASS}@${DB_INST} << END

When I tried to execute the above statement in putty, it was saying as "bad substitution"

So I am using UNIX script to assign the output to a variable.

count=sqlplus DB_USER/DB_PASS << END SELECT VERSION_NUMBER from GA_PERIODIC_REFRESH where MODULE_NAME in 'RoaminfoService'; exit; END echo $count

anubhava · Accepted Answer · 2014-09-25 07:22:33Z

4

You need exit also:

count=`sqlplus -s ${DB_USER}/${DB_PASS}@${DB_INST} <<END
set pages 0 echo off feed off
SELECT COUNT(column_name)
exit;
END`

answered Sep 25, 2014 at 7:22

anubhava

790k67 gold badges603 silver badges671 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1