How to read file names in the directory?

Shell Programming and Scripting
1

I am having n files in a directory i want to read all the file names from the script file .It is better if any one provide a sample script.

Elaborating the scenario:

i am having n number of sql files in a directory i am running all the sql files from a single script.

sqlplus uname/password@sid @<path of directory><file-name>

i want to all the file names .

2

I think it's better doing it this way instead of calling sqlplus for each sql file:

autoload.sh

#!/bin/sh

# create runall.all file

touch runall.all
 
# copy paths to sql files in current directory in the runall.all file
# format: @/path/to/sql/file
 
for i in *.sql
do
echo "@`pwd`/$i" >> runall.all
done

# rename runall.all to runall.sql

mv runall.all runall.sql
 
# append "EXIT" to every sql file to avoid a hang

for i in *.sql
do
echo EXIT >> $i
done

# start sql

sqlplus uname/password@sid @`pwd`/runall.sql

$ ls
autoload.sh	load-002.sql	load-004.sql
load-001.sql	load-003.sql	load-005.sql
$ sh autoload.sh
sqlplus: not found
$ ls
autoload.sh	load-002.sql	load-004.sql	runall.sql
load-001.sql	load-003.sql	load-005.sql
$ cat runall.sql
@/usr/home/myuser/sql/load-001.sql
@/usr/home/myuser/sql/load-002.sql
@/usr/home/myuser/sql/load-003.sql
@/usr/home/myuser/sql/load-004.sql
@/usr/home/myuser/sql/load-005.sql
EXIT
$

HTH

3

Not only for sqls i need to execute some utilities
so i need to read the all the file names. and in for loop i will pass individual file name as a parameter to that utility.

4

Not sure if I've understood you... Do you need further help?
Following for loop will read all files:

for i in *
do
sqlplus uname/password@sid @`pwd`/$i
done

Not sure if it will work...

5

cat /path-of-dir/*.sql | sqlplus "uname/password@sid"