Unix Shell Script to loop over Directory and send Filesname as parameters

Shell Programming and Scripting
1

Hi there
I'm new to UNIX scripting; I�m stuck with the following
I have an Oracle SQL script that takes three parameters
1- File Name
2- File Path
3- File creation date

Under UNIX I have a folder where files will be placed frequently and I need to upload those files to Oracle, what I need is a UNIX script that can do the following
Loop through Directory "/home/applmgr/snktmp"
Picks only files
Pass the file name to parameter &1
Pass the file path to parameter &2
Pass the file creation date to parameter &3

  Call Oracle Script passing parameters &1,&2,&3

End loop

Is the above possible? I already knows how to call the Oracle Script from UNIX
I�m only stuck on writing the UNIX part where it List the files attribute(name,path,date) and store them to parameters ,Looping until the last file in the directory

If the above is not possible,then how can I create the below from the command line
Filename{concatenation Mark}filePath{concatenation Mark}creationdate
Filename{concatenation Mark}filePath{concatenation Mark}creationdate
Filename{concatenation Mark}filePath{concatenation Mark}creationdate
Filename{concatenation Mark}filePath{concatenation Mark}creationdate

Thanks

2

...and also new to posting in this (and perhaps any other) forum.

Please edit your post and remove all the FONT and COLOR tags. They make it very hard to see the content of your post when editing a reply.

3

Oh i got it ,, didnt thought copying the text from MS WORD would do all that !! ..

thanks for the info

4

Edit your previous post and you will see the mess that Word created.