Oracle Alerts
Introduction: Oracle Alerts is something that can be used to Notify/Alert to one or multiple persons about an activity or change that occurs in the system. The alerts can also be used to call a procedure, run some sql script etc. There are 2 types of alert 1) Periodic Alert 2) Event Alert Periodic Alerts: These alerts are trigger periodically, hourly, daily, weekly, monthly etc based upon how it is setup to be triggered. When alert runs and the condition(SQL Query etc.) in the alerts fetches record, then the events specified in the alert are triggered. Ex. 1) Daily alert to send notification on the sales order on which credit check hold is applied for a day 2) Hourly alert to send notification on all the concurrent request that completed with error 3/If you want to know list of items created on that day at the end of day you can use periodic alerts repeating periodically by single day.This alert is not based on any chages to database.this alert will notify you everyday regardless of ...