Visit Our UNIX and Linux User Community

Full Discussion: Help with looping
Top Forums UNIX for Dummies Questions & Answers Help with looping Post 11632 by rooh on Monday 10th of December 2001 12:24:51 AM
Old 12-10-2001
Help with looping

Actually I have a file which consists data . for eg names.
Then I want my sql query to read this file and produce the output.
Currently I am using this
for i in `cat NAMES`
sqlplus -s $CONNECTID << EOF
spool rooh
set heading off
select name,address1,address2,street,occupation,age
from emp_detail
where name='$i';
spool off
but what happens is that it produces the spool file but contains only the last row fetched . But I want all the rows to be fetched in this file.
Can somebody show me where I am going wrong ?
Thanks in advance.

Test Your Knowledge in Computers #812
Difficulty: Medium
In CSS, the rgba() function define colors using the red-green-blue-accent (RGBA) model.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting


Hi I have around 100 users in sun server and have default home directory in /usr/home/<username> I want to clean their home directory time to time to make free space on root, as users generate many output files during usage of application. My idea is, generate a file with following command... (4 Replies)
Discussion started by: ishir
4 Replies

2. Shell Programming and Scripting

Looping through the directory

Hi, I have to write a KSH script to loop through the directory and transfer all the files through FTP. The source machine is the Network shared drive and the files in the directory needs to be FTPied to the UNIX server. For eg. Directory (Datasource) + Directory1 ... (6 Replies)
Discussion started by: mahalakshmi
6 Replies

3. Shell Programming and Scripting

for looping

I run into a issue when I try to do sorting of the following with ascending order, one round of for looping seems not working, anyone knows how to use shell or perl? $array = (5,0,3,2,7,9,8) (2 Replies)
Discussion started by: ccp
2 Replies

4. Shell Programming and Scripting

help on looping using if/for or while

Hello, where can I get usefull information on the use of looping with for , if and while with extensive examples. Also use of variables in scripts (1 Reply)
Discussion started by: sam4now
1 Replies

5. Shell Programming and Scripting

help with looping

vesselNames values: xxx yyy zzz vesselPlanned values: xxx zzz zzz zzz OIFS="" OIFS=$IFS IFS="\n" (2 Replies)
Discussion started by: finalight
2 Replies

6. Shell Programming and Scripting

Looping through entries

Hi everyone, I am having trouble looping through entries in a file. The file several entries that are separated by topics e.g. <Topic r:id="Top/World/Français"> </Topic> <Topic r:id="Top/World/Français/Actualité"> </Topic> <Topic r:id="Top/World/Français/Actualité/A_la_Une"> <link... (1 Reply)
Discussion started by: BlueberryPickle
1 Replies

7. Shell Programming and Scripting


Hi, Now I have written a script which sorts the records in the file and splits them according to some condition. Now, I need to modify the script so that it reads all the files one after the other and does the sorting & splitting. Pls help me in reading all the files in a directory and... (8 Replies)
Discussion started by: Sunitha_edi82
8 Replies

8. Shell Programming and Scripting


Hi evryone i need a help . i have a file xcv.the content is : accelerate i want a script which will run 1000 times in loop and changing the value to accelerate to acceler in 1st loop and in 2nd loop it will be again accelerate and so on . (6 Replies)
Discussion started by: Aditya.Gurgaon
6 Replies

9. Shell Programming and Scripting

looping while using getopts

so when i use rm file -i vv bb i can delete the first file vv but i cant seem to delete the second file bb as i tried to use shift on it, but it seems that it delete the first one and stops it without looping it to the next file. what is wrong with my coding ? #!/bin/bash function... (3 Replies)
Discussion started by: cman123
3 Replies

10. Shell Programming and Scripting


Hey guys, so I am trying to do a loop script that will go through each folder (no gui so just each domain has a folder) and grab out the databases being used on that domain. I know I would use mysql -e "show databases where not 'information_schema';" once in each directory to pull the actual... (3 Replies)
Discussion started by: dough
3 Replies
updatedb(8)						      System Manager's Manual						       updatedb(8)

updatedb - update a database for mlocate SYNOPSIS
updatedb creates or updates a database used by locate(1). If the database already exists, its data is reused to avoid rereading directo- ries that have not changed. updatedb is usually run daily by cron(8) to update the default database. EXIT STATUS
updatedb returns with exit status 0 on success, 1 on error. OPTIONS
The PRUNE_BIND_MOUNTS, PRUNEFS, PRUNENAMES and PRUNEPATHS variables, which are modified by some of the options, are documented in detail in updatedb.conf(5). -f, --add-prunefs FS Add entries in white-space-separated list FS to PRUNEFS. -n, --add-prunenames NAMES Add entries in white-space-separated list NAMES to PRUNENAMES. -e, --add-prunepaths PATHS Add entries in white-space-separated list PATHS to PRUNEPATHS. -U, --database-root PATH Store only results of scanning the file system subtree rooted at PATH to the generated database. The whole file system is scanned by default. locate(1) outputs entries as absolute path names which don't contain symbolic links, regardless of the form of PATH. --debug-pruning Write debugging information about pruning decisions to standard error output. -h, --help Write a summary of the available options to standard output and exit successfully. -o, --output FILE Write the database to FILE instead of using the default database. --prune-bind-mounts FLAG Set PRUNE_BIND_MOUNTS to FLAG, overriding the configuration file. --prunefs FS Set PRUNEFS to FS, overriding the configuration file. --prunenames NAMES Set PRUNENAMES to NAMES, overriding the configuration file. --prunepaths PATHS Set PRUNEPATHS to PATHS, overriding the configuration file. -l, --require-visibility FLAG Set the "require file visibility before reporting it" flag in the generated database to FLAG. If FLAG is 0 or no, or if the database file is readable by "others" or it is not owned by mlocate, locate(1) outputs the database entries even if the user running locate(1) could not have read the directory necessary to find out the file described by the data- base entry. If FLAG is 1 or yes (the default), locate(1) checks the permissions of parent directories of each entry before reporting it to the invoking user. To make the file existence truly hidden from other users, the database group is set to mlocate and the database per- missions prohibit reading the database by users using other means than locate(1), which is set-gid mlocate. Note that the visibility flag is checked only if the database is owned by mlocate and it is not readable by "others". -v, --verbose Output path names of files to standard output, as soon as they are found. -V, --version Write information about the version and licence of locate on standard output and exit successfully. EXAMPLES
To create a private mlocate database as an user other than root, run updatedb -l 0 -o db_file -U source_directory Note that all users that can read db_file can get the complete list of files in the subtree of source_directory. FILES
/etc/updatedb.conf A configuration file. See updatedb.conf(5). /var/lib/mlocate/mlocate.db The database updated by default. SECURITY
Databases built with --require-visibility no allow users to find names of files and directories of other users, which they would not other- wise be able to do. NOTES
The accompanying locate(1) utility was designed to be compatible to slocate and attempts to be compatible to GNU locate where possible. This is not the case for updatedb. AUTHOR
Miloslav Trmac <> SEE ALSO
locate(1), mlocate.db(5), updatedb.conf(5) mlocate Jun 2008 updatedb(8)

Featured Tech Videos

All times are GMT -4. The time now is 12:40 PM.
Unix & Linux Forums Content Copyright 1993-2020. All Rights Reserved.
Privacy Policy