Transferring the output from shell script to a variable

Question

I have written a script so that i can read from an oracle database and display it once i run the script. Is there any way that I can transfer the result to a variable ( Eg:output ) so that I can use if for some other calculations?

$ORACLE_HOME/bin/sqlplus -s /nolog<<EOF
connect useid/password@CFQ143
set pages 0 feed off
select count (platform) from platformspecific where platform='EF';
exit
EOF

Wouter · Accepted Answer · 2015-03-26 19:23:18Z

1

If your current command prints the output in the console window, you should be able to do:

VARIABLE="$($ORACLE_HOME/bin/sqlplus -s /nolog<<EOF
connect useid/password@CFQ143
set pages 0 feed off
select count (platform) from platformspecific where platform='EF';
exit
EOF)"

And print out your variable:

echo "${VARIABLE}"

answered Mar 26, 2015 at 19:23

Wouter

1,5677 gold badges28 silver badges36 bronze badges

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

1 Comment

Nidhin_toms Over a year ago

hey i got the answer by doing the same thing u did but removing the "

Nidhin_toms · Accepted Answer · 2015-03-26 19:46:31Z

0

this will also work:

var=$($ORACLE_HOME/bin/sqlplus -s /nolog<<EOF
connect useid/password@CFQ143
set pages 0 feed off
select count (platform) from platformspecific where platform='EF';
exit;
EOF) 
echo $var

answered Mar 26, 2015 at 19:46

Nidhin_toms

7374 gold badges19 silver badges31 bronze badges

Collectives™ on Stack Overflow

Transferring the output from shell script to a variable

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related