Download Oracle Streams Advanced Queuing User's Guide and Reference

Managing Queue Tables
multiple_consumers
compatible
comment
=> TRUE,
=> '8.1',
=> 'Overseas Shipping multiconsumer orders queue table');
END;
/
Example 8–7 Creating a Queue Table for Grouped Messages
BEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE(
queue_table
=> 'test.group_qtab',
queue_payload_type
=> 'test.message_typ',
message_grouping
=> DBMS_AQADM.TRANSACTIONAL);
END;
/
Example 8–8 Creating Queue Tables for Prioritized Messages and Multiple Consumers
BEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE(
queue_table
=> 'test.priority_qtab',
queue_payload_type
=> 'test.order_typ',
sort_list
=> 'PRIORITY,ENQ_TIME',
multiple_consumers
=> TRUE);
DBMS_AQADM.CREATE_QUEUE_TABLE(
queue_table
=> 'test.multiconsumer_qtab',
queue_payload_type
=> 'test.message_typ',
sort_list
=> 'PRIORITY,ENQ_TIME',
multiple_consumers
=> TRUE);
END;
/
Example 8–9 Creating a Queue Table with Commit-Time Ordering
BEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE(
queue_table
=> 'test.commit_time_qtab',
queue_payload_type
=> 'test.message_typ',
sort_list
=> 'COMMIT_TIME',
multiple_consumers
=> TRUE,
message_grouping
=> DBMS_AQADM.TRANSACTIONAL,
compatible
=> '10.0');
END;
/
Example 8–10
Creating an 8.1-Compatible Queue Table for Multiple Consumers
BEGIN
DBMS_AQADM.CREATE_QUEUE_TABLE(
queue_table
=> 'test.multiconsumer_81_qtab',
queue_payload_type
=> 'test.message_typ',
multiple_consumers
=> TRUE,
compatible
=> '8.1');
END;
/
Oracle Streams AQ Administrative Interface 8-7