Question on automated reporting

Apologies in advance if this a glaringly obvious question, but I've been unable to find quite the pointers I need and was hoping someone could point me in the right direction.

I'm looking to have Oracle 8i regularly run certain queries and save them to flat files. Now, my experience in this is with another database, where we wrote Perl scripts (that went 'log in, run query, stash output, save, log out') and stuck them in the cron. Nothing complicated.

Now I'm preparing to do the same thing with an existing Oracle database (on an HP-UX box), but I'd also like to do this the right way -- if Oracle has this sort of thing built in, I'd like to use that, and if there's a better way of doing it, I'd like to find that out, too.

Can anyone point me in the right direction for making this transition? Is there documentation I just haven't stumbled across yet, or a book that would be particularly helpful?

Any help or pointers are greatly appreciated.

Thanks,

Derek Zumsteg
robomilhous_at_hotmail.com Received on Thu Dec 28 2000 - 19:00:26 CST