Can you say in simple terms exactly what you expect to have at the end? There's stuff in the code you've posted that doesn't tie in anywhere (such as the SQL in @do_csv.sql, for example).
Sure.
Step1, extract an ID and put it in the result file.
Step2, read that file and use that record to run the .sql, then delete the result file.
Step3, repeat until while cycle ends.
At the end, you'd have a report_dettaglio_date that contains every result of the .sql run. I didn't post the content of the SQL file because I thought it was not important.
There's probably some easier way to do this, but I'm still practicing.
---------- Post updated at 10:36 AM ---------- Previous update was at 09:49 AM ----------
I removed the second cycle and left with this, but still no spool. So there was no accident delete of the file.
What bothers me is that I can't even do it in some other way. I really need to spool that output in a file.
Thanks again for helping me out guys, you're the best
That's a useless use of cat award. You don't need cat's help to read a file, and you don't need to run awk three times per line to extract three fields separated by ;
Why do you need it in the result file if you already have the ID? Wouldn't you rather have sqlplus' output?
Try redirecting the entire loop once instead of 1000 times for 1000 lines:
You might even be able to do
to put more than one sql query into one run of sqlplus.
I've been fidgeting around that syntax a bit, and it looks like it's spooling now. I don't know how, I just altered a few things and got rid of the "Stupid use of cat" but apparently that was enough for him.
If you were using your variables outside the while-loop, cat would have prevented them from being set, because the while-loop would be run in a subshell.
Hello all,
I am trying to spool a SQL query output file from back-end to desktop in a certain path but it didn't work,the query writes the output in a file in the same directory at the back-end.
note : i use the same query in sql developper and file was created in the desired path fine
code... (1 Reply)
Hi, I need to write a script that will run a simple select count(*) query and sends the result of that query to me via email.
Here's what I already have.
#!/bin/ksh
######################################################################
# File Name : counts.sh
# Created : 2019/27/19... (1 Reply)
Hi Guys,
Another questions to the genius over here. I have spool the dataf from the database into a .csv file. But can it be possible to have all the rows and column with the boundaries..for example the .csv file which i have is as below:
20140327 BU 9A 3
20140327 SPACE 9A 3
20140327... (8 Replies)
Hello,
How can I run this script every 1 hour and save its result to result.txt
ifconfig | grep 'inet addr:'| grep -v '127.0.0.1' | cut -d: -f2 | awk '{ print $1}'
Regards
Shaan (5 Replies)
Hi ,
Im spooling file from oracle to csv using shell script. Below is the code im using.. The o/p is not coming in right format.. Please help me out in this..
O/p is coming as header till batch id ,im not able to see date_stored,type,type1..
Please any one can give me some suggestion
... (1 Reply)
Hi
I have done a search for this but couldn't find much on it.
I am creating a tar file with the command below
tar cvf /export/home/user/backup/*Will this is being created I have a job spooling to 5 texts files in the following directory /export/home/user/backup/STATS/
The tar files... (1 Reply)
Since I'm not an expert in shell scripting, I have question on sending script result to file. I have script like this...
if condition=0: then
echo "service is not running" | mail -s "Server Status" uname@companyname
fi
sleep 10
if configtion=1: then
echo "service is not running" | mail -s... (3 Replies)
Hi,
I want to spool the output from a .sql file to a .txt file through shell script.
the contents of .sql are:
spool /arboru02/scripts/customer_profile_def.txt
select profile_id ||','|| account_no
from customer_profile_def;
spool off
exit
and shell scrip is like:
#!/bin/sh... (9 Replies)
Hi
From shell script i am invoking sqlplus to connect to oracle database and then i spool a csv file as with output. What i want to do is to change the file name with timestamp on it so after spooling finish shell script change file name with time stamp.
can someone help me to do that .
Thanks... (2 Replies)