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.
Dig Deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.