Insert to oracle table in a loop

view full story

http://unix.stackexchange.com – Requirement: In one server in a directory multiple files are present. I need to read the file names and populate into a oracle table. I have written the script like this, but its not working: #!/bin/bash names = find /home/devuser -name 'BI*' sqlplus -s schema_name/passwd << EOF for name in {names[@]} do insert into table1(file_name,status) values('$name','N'); done commit; exit its trowing DO INVALID IDENTIFIER. (HowTos)