What Procedures Can You Use To Register With An Aq?

1.	What Procedures Can You Use To Register With An Aq?
Answer» The user of an AQ is called a SUBSCRIBER, which can be added through the add_subscriber PROCEDURE. It can be altered USING the alter_subscriber procedure and removed using the drop_subscriber procedure of the dbms_aqadm package. Oracle also provides procedures to schedule propagation of MESSAGE in an AQ. This procedure is called schedule_propagation. It can be UNSCHEDULED using the unscheduled_propagation procedure.

Answer»

The user of an AQ is called a SUBSCRIBER, which can be added through the add_subscriber PROCEDURE.
It can be altered USING the alter_subscriber procedure and removed using the drop_subscriber procedure of the dbms_aqadm package.
Oracle also provides procedures to schedule propagation of MESSAGE in an AQ.
This procedure is called schedule_propagation.
It can be UNSCHEDULED using the unscheduled_propagation procedure.

Discussion