Oracle 数据库更改通知 [英] Oracle Database change notification
问题描述
我是 DCN 的新手,我可以使用它来检测表中某列的更新以及该表中的插入吗?我指的是 this
I am new to DCN, can I use it to detect updates on a column in my table along with inserts in that table ? I am referring to this
推荐答案
是的,您可以 - 为此更改通知.您需要使用查询注册СN侦听器以进行监视(它可以是整个表select * from your_table
或其中的一部分select column1 from your_table where column2='xxx'
)和回调函数.你应该明白它是异步机制的变化不会立即检测到,而是在一段时间后.您的文档链接显示了如何使用 JDBC 实现它.如果您想使用 Oracle,请阅读它PL/SQL 为此.
Yes, you can - Change Notifications made for that. You need to register СN listener with query to watch (it can a whole table select * from your_table
or part of it select column1 from your_table where column2='xxx'
) and callback function . You should understand that it is async mechanism changes will not detect immediately, but after some time.
Your documentation's link shows way how to implement it using JDBC.
Read it if you want to use Oracle PL/SQL for that.
这篇关于Oracle 数据库更改通知的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!