Use UTL_FILE package to write to a file, and use DBMS_JOB package to schedule it.
David Aldridge, "The Oracle Sponge" Senior Manager, Business Intelligence Development XM Satellite Radio Washington, DC Oracle ACE
Forum Rules
Reply With Quote