Oracle's preferred method of running SQL statements at a regularly scheduled time is to set up a job. In Oracle 10g+, you can use the DBMS_SCHEDULER package for this task.
Alternatively, you can set up a batch program or shell script which uses SQL*Plus to run the SQL statement. Once the program or script is created, it can be scheduled with Windows task scheduler or from cron in Unix/Linux.
This was first published in July 2008