Kris' blog
This blog has moved to
http://krisrice.io
Thursday, June 16, 2016
SQLcl and Query Change Notification
The database has had Query Change Notification for a while but to use it required a custom program. Such as Tim outlines on his blog
https://oracle-base.com/articles/10g/dbms_change_notification_10gR2
Since SQLcl has Nashorn, now it can be integrated with a few lines of javascript to get notified when changes happen. The script is below and posted. The catch is QCN only works on Varchars and Numbers.
Newer Post
Older Post
Home