Select multiple values from an Oracle database and assign it to two dimensional array

Shell Programming and Scripting
1

hi

I have two tables in oracle DB and am using a joining query which will result in the output as follows.

i need to assign it to a two dimensional array and use it for my further calculations.

the way i tried is as follows.

#!/bin/ksh
export ORACLE_HOME=/u01/app/oracle/product/9.2.0
export PATH=$PATH:$ORACLE_HOME/bin
set -A SQL_RESULTS_ARRAY $(
sqlplus -S <<EOF
USER/PWD@SID
SET PAGESIZE 0 FEEDBACK OFF VERIFY OFF ECHO OFF SERVEROUT ON TIME OFF TIMING OFF
select l.RESOURCE_MSISDN,l.CRITERIA,l.RANGE,lm.X,lm.Y from LANDMARK_ALARM_CONF l, LANDMARK lm where l.LANDMARK_ID=lm.LANDMARK_ID;
EOF
)

SQL_ARRAYCOUNT=${#SQL_RESULTS_ARRAY[*]}
SQL_ARRAYIDX=0

while (( $SQL_ARRAYIDX < $SQL_ARRAYCOUNT ))
do
 print "SQL_ARRAY[$SQL_ARRAYIDX]=(${SQL_RESULTS_ARRAY[$SQL_ARRAYIDX]})"
 SQL_ARRAYIDX=$(($SQL_ARRAYIDX+1))
done

exit 0

this returns the output as

i want the output to be like

so that i can do some calculations based on
this assignment to array....i will come to this forum again if i have a doubt in my calculations which is going to happen based on this success first.
PLS help me out...

2

There are no multi-dimensional arrays in shell. You have to "fake" it.
Here is a bash example of faking it:
Arrays