Create a Connection Factory 

N/A 

N/A 

AQjmsFactory.getQueueConnectionFactory

AQjmsFactory.getTopicConnectionFactory 

Create a Queue Table 

DBMS_AQADM.create_queue_table 

Create AQQueueTableProperty, then

AQSession.createQueueTable 

AQjmsSession.createQueueTable 

Get a Queue Table 

Use <schema>.<queue_table_name> 

AQSession.getQueueTable 

AQjmsSession.getQueueTable 

Alter a Queue Table 

DBMS_AQADM.alter_queue_table 

AQQueueTable.alter 

AQQueueTable.alter 

Drop a Queue Table 

DBMS_AQADM.drop_queue_table 

AQQueueTable.drop 

AQQueueTable.drop 

Create a Queue 

DBMS_AQADM.create_queue 

AQSession.createQueue 

AQjmsSession.createQueue 

Get a Queue 

Use <schema>.<queue_name> 

AQSession.getQueue 

AQjmsSession.getQueue 

Create a Non-persistent Queue 

DBMS_AQADM.create_np_queue 

Not supported 

Not supported 

Create a Multi-consumer Queue/Topic 

DBMS_AQADM.create_queue

in a queue table with multiple consumers enabled 

AQSession.createQueue

in a queue table with multiple consumers enabled 

AQjmsSession.createTopic

in a queue table with multiple consumers enabled 

Get a Multi-consumer Queue/Topic 

Use <schema>.<queue_name> 

AQSession.getQueue 

AQjmsSession.getTopic 

Alter a Queue/Topic 

DBMS_AQADM.alter_queue 

AQQueue.alterQueue 

AQjmsDestination.alter 

Start a Queue/Topic 

DBMS_AQADM.start_queue 

AQQueue.start

AQQueue.startEnqueue

AQQueue.startDequeue 

AQjmsDestination.start 

Stop a Queue/Topic 

DBMS_AQADM.stop_queue 

AQQueue.stop

AQQueue.stopEnqueue

AQQueue.stopDequeue 

AQjmsDestination.stop 

Drop a Queue/Topic 

DBMS_AQADM.drop_queue 

AQQueue.drop

AQQueueTable.dropQueue 

AQjmsDestination.drop 

Grant System Privileges 

DBMS_AQADM.grant_system_privilege 

Not supported 

AQjmsSession.grantSystemPrivilege 

Revoke System Privileges 

DBMS_AQADM.revoke_system_privilege 

Not supported 

AQjmsSession.revokeSystemPrivilege 

Grant a Queue/Topic Privilege 

DBMS_AQADM.grant_queue_privilege 

AQQueue.grantQueuePrivilege 

AQjmsDestination.grantQueuePrivilege

AQjmsDestination.grantTopicPrivilege 

Revoke a Queue/Topic Privilege 

DBMS_AQADM.revoke_queue_privilege 

AQQueue.revokeQueuePrivilege 

AQjmsDestination.revokeQueuePrivilege

AQjmsDestination.revokeTopicPrivilege 

Verify a Queue Type 

DBMS_AQADM.verify_queue_types 

Not supported 

Not supported 

Add a Subscriber¹ 

DBMS_AQADM.add_subscriber 

AQQueue.addSubscriber 

See Table 3-3, "Comparing AQ Programmatic Environments: Operational Interfaces" 

Alter a Subscriber 

DBMS_AQADM.alter_subscriber 

AQQueue.alterSubscriber 

See Table 3-3, "Comparing AQ Programmatic Environments: Operational Interfaces" 

Remove a Subscriber 

DBMS_AQADM.remove_subscriber 

AQQueue.removeSubscriber 

See Table 3-3, "Comparing AQ Programmatic Environments: Operational Interfaces" 

Schedule Propagation 

DBMS_AQADM.schedule_propagation 

AQQueue.schedulePropagation 

AQjmsDestination.schedulePropagation 

Enable a Propagation Schedule 

DBMS_AQADM.enable_propagation_schedule 

AQQueue.enablePropagationSchedule 

AQjmsDestination.enablePropagationSchedule 

Alter a Propagation Schedule 

DBMS_AQADM.alter_propagation_schedule 

AQQueue.alterPropagationSchedule 

AQjmsDestination.alterPropagationSchedule 

Disable a Propagation Schedule 

DBMS_AQADM.disable_propagation_schedule 

AQQueue.disablePropagationSchedule 

AQjmsDestination.disablePropagationSchedule 

Unschedule a Propagation  

DBMS_AQADM.unschedule_propagation 

AQQueue.unschedulePropagation 

AQjmsDestination.unschedulePropagation