Does Oracle Support Events?
MySQL supports events where i can set up something to happen in a specified time period
Eg: Update the salary's every month
Eg: Update something every year
Eg: Change the status of a book to "overdue" in a week
Etc etc etc
H开发者_开发问答ow do I do this in Oracle?
You can use DBMS_SCHEDULER
to do perform scheduled events.
Official Documentation: http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/scheduse.htm
Alternate: http://www.comp.dit.ie/btierney/oracle11gdoc/server.111/b28310/scheduse.htm
精彩评论