 |
|
DBMS_CHANGE_NOTIFICATION package tips
Oracle Tips by Burleson Consulting |
DBMS_CHANGE_NOTIFICATION
<< Return to the index
Oracle 11g provides the following information about the DBMS_CHANGE_NOTIFICATION package:
Description of the DBMS_CHANGE_NOTIFICATION package:
FUNCTION DBMS_CHANGE_NOTIFICATION.CQ_NOTIFICATION_QUERYID RETURNS NUMBER
PROCEDURE DBMS_CHANGE_NOTIFICATION.DEREGISTER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
REGID NUMBER IN
PROCEDURE DBMS_CHANGE_NOTIFICATION.ENABLE_REG
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
REGID NUMBER IN
FUNCTION DBMS_CHANGE_NOTIFICATION.NEW_REG_START RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
REGDS CHNF$_REG_INFO IN
FUNCTION DBMS_CHANGE_NOTIFICATION.NEW_REG_START_OC4J RETURNS NUMBER
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
REGDS CHNF$_REG_INFO_OC4J IN
PROCEDURE DBMS_CHANGE_NOTIFICATION.REG_END
PROCEDURE DBMS_CHANGE_NOTIFICATION.SET_ROWID_THRESHOLD
Argument Name Type In/Out Default?
------------------------------ ----------------------- ------ --------
TBNAME VARCHAR2 IN
THRESHOLD NUMBER IN
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
 |
 |
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
