Oracle provides the dbms_aqadm package to create an advanced queue. This package can be used to create, alter and drop AQ.
The procedures that provide these functions are given as follows:
? Create_queue_table
n A!ter_queue__table
? Drop_queue_tabie
? Createjqueue
? Alter__queue
? Drop_queue
? Start^queue
? Stop_queue.