Home » SQL & PL/SQL » SQL & PL/SQL » want output in excel automatically (WINDOWS XP)
want output in excel automatically [message #396140] Sat, 04 April 2009 05:05 Go to next message
siva.n.subramanian
Messages: 10
Registered: April 2009
Junior Member
Hi all,

Let me take this opportunity to introduce myself as this my 1st post. My name is Siva working with reputed company.

My query is:

I have a query which I want to run it @ a particular time. The o/p of this query should get saved in excel and get stored in a particular location.
All this should be done automatically.
Can some 1 please help. I use toad software.

Thanks and Regards
Siva

[Updated on: Sat, 04 April 2009 05:07] by Moderator

Report message to a moderator

Re: want output in excel automatically [message #396151 is a reply to message #396140] Sat, 04 April 2009 06:04 Go to previous messageGo to next message
user2004
Messages: 33
Registered: April 2009
Member
Use Cron job if u want to run in Unix

Quote:

The o/p of this query should get saved in excel and get stored in a particular location.


Use UTL_FILE. Search in google

please find the following link
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:95212348059


[Updated on: Sat, 04 April 2009 06:15]

Report message to a moderator

Re: want output in excel automatically [message #396158 is a reply to message #396140] Sat, 04 April 2009 07:03 Go to previous message
cookiemonster
Messages: 13965
Registered: September 2008
Location: Rainy Manchester
Senior Member
Oracle Discoverer can do all that.
Previous Topic: to different column depending on a value
Next Topic: Simple operations on Columns hanging
Goto Forum:
  


Current Time: Tue Feb 18 21:00:53 CST 2025