Visit Our UNIX and Linux User Community


How to read file names in the directory?


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to read file names in the directory?
# 1  
Old 04-24-2010
How to read file names in the directory?

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  
Old 04-24-2010
I think it's better doing it this way instead of calling sqlplus for each sql file:

autoload.sh
Code:
#!/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

Code:
$ 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  
Old 04-24-2010
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  
Old 04-24-2010
Not sure if I've understood you... Do you need further help?
Following for loop will read all files:
Code:
for i in *
do
sqlplus uname/password@sid @`pwd`/$i
done

Not sure if it will work...
# 5  
Old 04-25-2010
Maybe just input the files to sqlplus:

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

Previous Thread | Next Thread
Test Your Knowledge in Computers #57
Difficulty: Easy
In a Database Management System (DBMS), the content and the location of the data is defined by the meta data.
True or False?

9 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Renaming the file names in a directory

Hi, I have about 60 files in a directory and need to rename those files. For example the file names are i_can_phone_yymmdd.txt (where yymmdd is the date. i.e 170420 etc) i_usa_phone_1_yymmdd.txt i_eng_phone_4_yymmdd.txt The new file names should be phone.txt phone_1.txt phone_4.txt I am... (4 Replies)
Discussion started by: naveed
4 Replies

2. Shell Programming and Scripting

Compare file names on directory

Dears, Would you please help on following bash script: I want to get the most recent file named alfaYYYYMMDD.gz in one directory: for example: in directory /tmp/ ls -ltr alfa20130715.gz holding.gz alfa20130705.gz sart.txt merge.txt.gz alfa20130802.gz my result shoud be... (1 Reply)
Discussion started by: maxsub
1 Replies

3. UNIX for Dummies Questions & Answers

List Directory names which have the file

Hi All, Can any one help me to list out the directory names which contain the specified file. See for example File name : file.201307014.LKT Have the directory structure as below. /app/work/data/INDIA/file.201307014.LKT /app/work/data/AMERICA/file.201307014.KTP... (5 Replies)
Discussion started by: Balasankar
5 Replies

4. Shell Programming and Scripting

Grepping file names, comparing them to a directory of files, and moving them into a new directory

got it figured out :) (1 Reply)
Discussion started by: sHockz
1 Replies

5. Shell Programming and Scripting

Searching for file names in a directory while ignoring certain file names

Sun Solaris Unix Question Haven't been able to find any solution for this situation. Let's just say the file names listed below exist in a directory. I want the find command to find all files in this directory but at the same time I want to eliminate certain file names or files with certain... (2 Replies)
Discussion started by: 2reperry
2 Replies

6. UNIX for Dummies Questions & Answers

How can I sort the file names in the directory

Hi , I have a list of files in the directory I want to sort based on the file name. But in the middle of filename contains the number based on that I need to sort.Could you suggest me on the same? Example filenames: /user1$ls RS.DEV.ISV.F1.RS.REFDATA.DATA... (1 Reply)
Discussion started by: praveen.thumati
1 Replies

7. UNIX for Dummies Questions & Answers

Change All File Names in a Directory

Hi, If I have a directory full of say 100 random files, and I would like to organize them, for example: FILE001, FILE002, FILE003, FILE004, etc. How would I do this from Terminal, instead of manually changing each file? I'm using Mac OS X, if that makes a difference. Thank you in advance... (8 Replies)
Discussion started by: andou
8 Replies

8. Shell Programming and Scripting

directory names in a flat file

Hi, Consider a flat file abc.conf contains some rows. Each row contains the directory name with full path. now I want to find a particular file in every directory which are mentioned in the abc.conf file. How it can be done through unix shell script. (2 Replies)
Discussion started by: surjyap
2 Replies

9. UNIX for Advanced & Expert Users

File and Directory Names become hidden

Something very weird has been happening when I'm creating files and directories. When I create a directory, at times depending on the directory name and depth, it becomes hidden and can only be seen typing "ls -a". When I say the name of the directory matters, "my_c++" will be hidden but using... (10 Replies)
Discussion started by: dbinsol1
10 Replies

Featured Tech Videos