How can i store the below sql connect and query in a variable within a shell script

Asked Feb 12 '21 at 08:46

Active Feb 12 '21 at 08:53

Viewed 28 times

I am trying to store the SQL query below in a variable within a shell script.

sqlplus -s 'username/password@"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=hostname.com)(PORT=portnumber)))(CONNECT_DATA=(SERVICE_NAME=Servicename)))"' <<EOF
SPOOL /tmp/out.txt
select count(scheduletaskid)from devicetask where status=6 group by coreid;
SPOOL OFF
exit;
EOF

edited Feb 12 '21 at 08:53

Mahyar Mottaghi Zadeh

1,022
3
16
26

asked Feb 12 '21 at 08:46

Abhi093

Or this one : https://stackoverflow.com/questions/28565623/can-a-bash-heredoc-put-its-result-directly-into-a-variable – Aserre Feb 12 '21 at 08:55
what have you tried and what was your problem buddy? – Abilogos Feb 12 '21 at 09:03
**Don't use `eval`!** The accepted answer on the duplicate suggests this, but don't trust it just because it is accepted. – tripleee Feb 12 '21 at 10:40

How can i store the below sql connect and query in a variable within a shell script

0 Answers0