Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
sql submitted on timer
You could use the dbms_job package inside Oracle<br> to schedule the running of a stored procedure. The<br> stored procedure in turn could perform the select<br> into a cursor object, open up a file for writing,<br> then loop through the cursor and write out to your<br> file.<br> <br>
