How do I select all database change notifications registered via JDBC driver by my DB user?
select * from user_change_notification_regs
How do I clean all of my DB change notifications?
Database change notifications registered via JDBC driver can be deregistered only the same way – using JDBC driver. Therefore you need to execute this code:
This code can be downloaded here.
More info about JDBC database change notifications can find in Database JDBC Developer’s Guide