UNIX for Dummies Questions & Answers

Dear Experts,
I am new to UNIX and I have a script below and in this test case I am reading the names of the files in the present directory into a variable and then looping through each file name and displaying the name back to the screen. The problem I have is although there are 5 files in the directory, it only ever displays the name of the first file and then stops. Can you assist?
Many thanks,
Mark

#!/bin/csh
set files = `ls`
#
foreach file ( $files )
echo 'File name:' $file
end

Code:

#!/bin/csh
foreach file ( * )
echo 'File name:' $file
end

Many thanks for your feedback. What are really require is to do something like this:

set files = `ls -a /file_path_of_files_to_process_dir`

set archive = '/archive_dir'

foreach file ( $files )

open an sqlplus connection

exec my_custom_PL/SQL_package.custom_procedure($file)

close sqlplus connection

mv $file $archive

end

Therefore, in this example I wish to pick up files from a different directory and then take the file name and use it in a parameter call to a custom PL/SQL procedure and then once processed, move the file to an archive directory. I wish to repeat this until no more files exist. What would be the UNIX code (ignor the sqlplus and PL/SQL component) to retrieve files from another location and then process?
Thanks for your assistance,
Mark

a pointer,

Code:

DIR=/path/where/files/are/available/
 ARCHIVEDIR=/path/to/archive/files/
 
 ls -1 $DIR | while read file
 do
   echo "Processing file $file"
   <your process here>
   echo "Processed file $file"
   mv $DIR$file $ARCHIVEDIR
   compress $ARCHIVEDIR$file
 done

I've just tested that and it works for me. That is a great help - many thanks for your time!
Mark