Oracle 支持事件吗?
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
How do I do this in Oracle?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
您可以使用
DBMS_SCHEDULER
来执行计划的事件。官方文档:http://download.oracle.com /docs/cd/B28359_01/server.111/b28310/scheduse.htm
备用:http://www.comp.dit.ie/btierney/oracle11gdoc/server.111/b28310/scheduse.htm
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