Home » SQL & PL/SQL » SQL & PL/SQL » Save Output as Excel file and then email the File
Save Output as Excel file and then email the File [message #228721] Tue, 03 April 2007 22:29 Go to next message
feroze
Messages: 144
Registered: September 2005
Location: chicago
Senior Member
Hi,

Basically we want the output of a simple select statement

select * from table_name; and run this select statement daily at 11 PM as DBMS_JOB save the result output as a spread sheet and email the file to some email id's we have.

To start with i can schedule DBMS_JOB, and run that select statement and save the output, Question is where it will save the file i mean in which location some where in Oracle User Account folder on the system or the directory we create, and from there how can it pick today's file(latest file every day) and email to fix email address, Any clues how can i do this.

Version is Oracle 9i Rel 2 and OS is Solaris 5.9


Thanks

[Updated on: Tue, 03 April 2007 22:39]

Report message to a moderator

Re: Save Output as Excel file and then email the File [message #228722 is a reply to message #228721] Tue, 03 April 2007 22:32 Go to previous message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
$ mailx -s Subject email@example.com < reportfile.txt
Previous Topic: automatic primarykey
Next Topic: sql swap
Goto Forum:
  


Current Time: Sun Dec 11 02:00:47 CST 2016

Total time taken to generate the page: 0.09174 seconds