How to store query multiple result in shell script variable(Array)?

2 votes

2 answers

2291 views

                          I'm trying to do a query and store **every row** result in an array element in ksh (maybe bash).
I do:

    result=($($PATH_UTI/querysh "
    set heading off
    set feedback off
    SELECT columnA,columnb FROM user.comunication;"))

I have that:

    row1 = HOUSE CAR
    row2 = DOC   CAT
    echo "${result}" and it gives me HOUSE

But I would like to get:

    echo "${result}" gives: "HOUSE CAR"

Asked by defekas17 (23 rep)

Oct 28, 2021, 03:47 PM
Last activity: Oct 28, 2021, 04:33 PM

How to store query multiple result in shell script variable(Array)?

Related Questions