Question: What is the Oracle 11g
SQL level change notification process? How does Oracle
detect when a change has been made to a previous SQL
The Oracle Call Interface (OCI) in 11g has created a new
feature that will send an application a notification
whenever the results of a previous query have changed.
This is an outstanding features for Oracle database that
monitor equipment and processes, because the query-level
change notification can be used to refresh an end-user
screen only when a change has been made to the results of
the previous SQL query that mapped-out the data to the
See the Oracle 11g OCI programmers guide
documentation for details on using
continuous SQL level change detection.