using loops to traverse through the array in linux to execute query within sqlplus

Question

I have shell script with following code:

#! /bin/bash

MODEL=$1
declare -a arr=("porsche" "lamborgini" "tesla")

for i in ${arr[@]}
do
sqlplus -s un/pass <<!
set verify off
INSERT INTO tbl1 (par1, par2, par3, datetime_parm)
VALUES('$MODEL', '${arr[i]}', (select count(s) from table i), SYSTIMESTAMP);
COMMIT;
exit;
!
done

For some reason it is overwriting the previous value it gets from the array and i ends up only populating the table with 'tesla'.

Does anyone know what i am doing wrong?

Angelina · Accepted Answer · 2013-11-14 19:00:14Z

1

I figured it out.

#! /bin/bash

MODEL=$1
declare -a arr=("porsche" "lamborgini" "tesla")

for i in ${arr[@]}
do
sqlplus -s un/pass <<!
set verify off
INSERT INTO tbl1 (par1, par2, par3, datetime_parm)
VALUES('$MODEL', '$i', (select count(s) from table i), SYSTIMESTAMP);
COMMIT;
exit;
!
done

answered Nov 14, 2013 at 19:00

Angelina

2,28512 gold badges47 silver badges92 bronze badges

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

1 Comment

Angelina Over a year ago

All I had to do is pass variable $i

Collectives™ on Stack Overflow

using loops to traverse through the array in linux to execute query within sqlplus

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related