2.3.49 DROP QUEUE

Table of Contents Previous Next


2 The SQL Language : 2.3 SQL Commands : 2.3.49 DROP QUEUE

Advanced Server includes extra syntax (not offered by Oracle) with the DROP QUEUE SQL command. This syntax can be used in association with DBMS_AQADM.
DROP QUEUE -- drop an existing queue.
Use DROP QUEUE to drop an existing queue:
DROP QUEUE allows a superuser or a user with the aq_administrator_role privilege to drop an existing queue.
Include the IF EXISTS clause to instruct the server to not return an error if the queue does not exist. The server will issue a notice.

2 The SQL Language : 2.3 SQL Commands : 2.3.49 DROP QUEUE

Table of Contents Previous Next