Re: Launch an agent which create an Excel file

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