Search Results

thanks,
it is generating the desired result in file.
Though there is one issue.
output shown in file is like:
more out.txt

ajay




there are blank spaces which should not be there
...

the thing is when i do like you said it gives output like
name
--------
ajay



i want the output file to have only ajay

Please use CODE tags as required by forum rules!

I am trying to write shell script that will pull output from sql db and store it in file in UNIX.
script:-
#echo $conn
sqlplus -l $conn << EOF
select name from employee where id = $1;
/
exit...