ALTER_QUEUE_TABLE v17
Use the ALTER_QUEUE_TABLE
procedure to modify an existing queue table. The signature is:
ALTER_QUEUE_TABLE ( <queue_table> IN VARCHAR2, <comment> IN VARCHAR2 DEFAULT NULL, <primary_instance> IN BINARY_INTEGER DEFAULT 0, <secondary_instance> IN BINARY_INTEGER DEFAULT 0,
Parameters
queue_table
The (optionally schema-qualified) name of the queue table.
comment
Use the comment
parameter to provide a comment about the queue table.
primary_instance
primary_instance
is accepted for compatibility and stored but is ignored.
secondary_instance
secondary_instance
is accepted for compatibility but is ignored.
Example
The following command modifies a queue table named work_order_table
:
EXEC DBMS_AQADM.ALTER_QUEUE_TABLE (queue_table => 'work_order_table', comment => 'This queue table contains work orders for the shipping department.');
The queue table is named work_order_table
. The command adds a comment to the definition of the queue table.
- On this page
- Parameters
- Example