Executing multiple sql files in a bash for loop

Question

I'm trying to run the following lines of code in bash to run multiple files on a database.

#!/bin/bash
for file in ${arrIN}; do
    echo "Executing ${file}..";
    sqlplus ${db_user}/${db_password}@${db_host}:1521/${db_sid} @${file};
done

For some reason, it will only execute the first file on the database, but won't keep executing them. When I check how many files are in arrIn it prints two, so I know there are multiple files. When I run this:

file1=${arrIN[0]}
file2=${arrIN[1]}    
sqlplus ${db_user}/${db_password}@${db_host}:1521/${db_sid} @${file1}
sqlplus ${db_user}/${db_password}@${db_host}:1521/${db_sid} @${file2}

It executes both files as expected. I would like to acomplish this in a for loop

Nic3500 · Accepted Answer · 2022-07-12 00:32:21Z

1

#!/bin/bash

arr=("0000" "1111")

for i in "${arr[@]}"
do
    echo $i
done

you need [@] to loop on all the items in the array.
without [@], it just loops on the first item, like you experienced.

edited Jul 12, 2022 at 0:32

answered Jul 11, 2022 at 14:28

Nic3500

8,68410 gold badges33 silver badges45 bronze badges

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

2 Comments

ufopilot Over a year ago

You forgot to double quote "${arr[@]}"

Nic3500 Over a year ago

Indeed, fixed, thanks.

Collectives™ on Stack Overflow

Executing multiple sql files in a bash for loop

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related