Oracle Alert Issue
Hello All,
This is regarding Oracle Alerts,
1. I wanted to create AFTER UPDATE event base alert, But i want to fire alert only if specific column is updated.
For eg ; Table TABLE_ABC and if column COL1 is updated, then only alert should run and notification should be sent,
If any other column of same table is updated, then notification should not be sent.
2. Can we get old and new value in oracle alert AFTER UPDATE event.
Could you please help to get this done through Oracle Alerts.?
Thanks In advanced.