Oracle output to excel file

Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation. Details required : characters remaining Cancel Submit 1 person found this reply helpful.

Oracle says check with Microsoft that which setting is preventing to open files. Regards Pankaj Sharma. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question 1. Report abuse. Details required :. Cancel Submit. Hi Pankaj Sharma, Thanks for sharing your experience in our community.

Do other types of files also cannot open normally? Appreciate again for your cooperation to share the above information. Best regards, Gloria. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. Hello Gloria Thank you! If need I can upload video of file opening, and excel output files attachments , however do not able to found attach such files in this communication, Regards Pankaj.

Hi Pankaj Sharma, Thanks for your time to post back, please do not mind my late reply due to Weekends. Hello Gloria Thanks for your time again! Is there any way to achieve this? I have already tried to find some solutions but no luck so far. Since I want to implement this is live production server, I cannot use any third party packages e. I believe it's not possible with spool. You can use the export option of SQL Developer though.

I have used for loop since it does this in multiple servers. Now I want to save the output in a excel in the below format. Can someone please help? The output which I get Server1 : count Hi , i am generating some data by firing sql query with connecting to the database by my solaris box.

The below one should be the header line of my excel ,here its coming in separate row. Hi guys - I have a file and output like this below: File: myfile. Hi All, I am fetching oracle query result in shell variable. As columns numbers are more the output wraps in unix terminal. Problem in formatting output of SQL query in excel sheet in shell script. Hi Guys.. Need your help to format the output of my shell script.

I am using spool command to take out put in csv file. Problems with storing oracle sqlplus query output shell script. Hello everyone, I have a RHEL 5 system and have been trying to get a batch of scripts each in a separate variables and they are not working as expected.

I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't Shell Script to execute Oracle query taking input from a file to form query. Hi, I need to query Oracle database for users.

I have these users in a file. So, I would like to run differen select queries on multiple databases..