Oracle's preferred method of running SQL statements at a regularly scheduled time is to set up a job. In Oracle...
By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
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.
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.