Search Results

Added the termout off and still get the log. Is it conflicting with any of the other setting?
Regards,
Hope

By the way, is it possible to suppress(just don't show ) the script log report, I need to see the data in the excel sheets only. If yes, how do you do that?

Regards,
HOPE

Thank you Akshay and Rudic
Sorry, I was putting comma between the tables in the table array. tables = ( table1, table2) it is all good now.

I really appreciate your expertise.
Regards,...

Hello Rudic,
Thank you for your time,
Are you still using the loop, I have so many tables to spool from and wanted to make sure my code is efficient.
In your code, where are you keeping the...

Is it possible to spool it to different excel files? It is now dumping all the tables in one excel, which is not useful for my purpose.
Thanks in advance.

Hope

Thank you Akshay,

It is a very good code, It is putting all the files in one file, how can I spool each query to different CSV files. (Eg. Table1 to table 1.csv, table 2 to table2.csv ).
...

Anyone who has done this before? Help please !!

Here is another try, Any body who can make this more efficient? I don't want to use the setting and the sql connection more than once.
Thanks ,
Hope



FIle = "geo_JOB.csv"

sqlplus -s...

Thank you Rudic,
What do you mean step by step?
geo_JOB1.csv
geo_JOB2.csv at the beginning of the script? Can you elaborate if possible?

Regards,
Hope



export...

Thank you for your feedback,

Sorry for choosing a confusing variable "Export". I have changed it to Download_job.
The first table is exported to the first file as needed and unfortunately, there...

Hello All,
just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table.
Can you please suggest why? or any...

Thanks all for your replies.
I think I found the problem. Every time I try to see the csv output file, the sheets are open on my window and never tried to close it. When I close all the current...

Thanks Robin,
I have tried that and still got the same error " not spooling currently".
Any more ideas why?

Regards,
Hope

I have this UNIX script code with a query to export sql table in Oracle and export to csv file. The code gets the data correctly. However, when I run the script second time, I got the error message...

Many many Thanks.
Hope

Thanks for the quick reply.
The error is gone now but the email is blank(no file names) even though there are file more than 240 minutes.
Any error in the script?

Regards,
Hope

Greeting!!
I wrote the below script to e-mail me only file names in a specific directory when a file is delayed for some time in a that directory. I am getting unexpected eof error message.
I...