How to store multiple row output in a bash array?

Question

I have a select statement

sqlplus [credentials] select variable from table;

It returns 6 rows and I need to store them as an array in bash array variable.

jman · Accepted Answer · 2011-07-27 21:15:52Z

6

array=(`sqlplus [credentials] select variable from table;`)
echo ${array[*]}

edited Jul 27, 2011 at 21:15

answered Jul 27, 2011 at 19:16

jman

11.7k5 gold badges41 silver badges61 bronze badges

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

Comments

mivk · Accepted Answer · 2012-11-01 21:29:42Z

5

If your variables contain spaces and you want the array to have an element for each line of output (as opposed to each word of output), you also need to set your IFS. And you may want to use quotes when using the array:

SaveIFS="$IFS"

IFS=$'\n'
array=( $(sqlplus [credentials] select variable from table;) )
echo "${array[*]}"

IFS="$SaveIFS"

answered Nov 1, 2012 at 21:29

mivk

15.5k5 gold badges89 silver badges83 bronze badges

Collectives™ on Stack Overflow

How to store multiple row output in a bash array?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related