Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Launch an agent which create an Excel file

Re: Launch an agent which create an Excel file

From: Sybrand Bakker <oradba_at_sybrandb.demon.nl>
Date: Thu, 03 Jan 2002 18:50:02 +0100
Message-ID: <gc693u8rro7jst30gdpafai644hla9m72t@4ax.com>


On Thu, 3 Jan 2002 14:19:11 +0100, "Hassen AHLAMINE" <cainmaro_at_hotmail.com> wrote:

>Hi everybody!
>
>I'd like to know if it is possible to create an Oracle agent on a server
>which run an SQL Request in order to gather data from tables an to save it
>in an xls file or txt file (xls is better)
>This agent must be ran every week...
>
>Thank you for the help you could bring me...
>

The nearest solution is a stored procedure submitted by dbms_job which creates a CSV file as output by means of utl_file.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jan 03 2002 - 11:50:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US