Hi All,

Need suggession on following proble:
We need to send output of several views to different people via email in .csv or .xls file, currently it is completely manual process, any idea how can we achieve this in Oracle 9i?

Rupen:
I am not familiar with Oracle 9i, however I own the the book, PL/SQL Programming for Oracle Database 10g, According to the book's index for scheduling tasks, the following is listed:

• DBMS_JOB
• Oracle Scheduler
• procedure execution on 30-minute interval
• purging e-mail table

This should give you a starting point, especially with the DBMS_JOB.

Hope this helps.

__________________
Disclaimer: The above comments are solely the opinion of one person and not to be construed as a directive or an incentive to commit fraudulent acts.

If using 10 g better go for DBMS_SCHEDULER.

__________________
Regards
Debasis