Shell Programming and Scripting

echo "insert into table1 (col1, col2) values (val1, val2);" | sqlplus /

count=$(find .. -maxdepth 1 -type f|wc -l)
echo $count
let count=count+1 # Increase by one, for the next file number
echo $count

file_list=( $(find . -maxdepth 1 -type f) )
file_count=${#file_list[@]}

echo "Number of files: $file_count"
for file in ${file_list[@]}
do
    line_count=1
    while read line
    do
        process_line line
        (( line_count++ ))
    done < $file
    echo "Number of lines processed in $file: $line_count"
done