DROP QUEUE v10
Advanced Server includes extra syntax (not offered by Oracle) with the
DROP QUEUE SQL command. This syntax can be used in association with
DROP QUEUE -- drop an existing queue.
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.
The name (possibly schema-qualified) of the queue that is being dropped.
IF EXISTS clause to instruct the server to not return an error if the queue does not exist. The server will issue a notice.
The following example drops a queue named