VIEW: SYS.DBA_AQ_AGENTS

Source

View Text - Preformatted

SELECT u.agent_name, decode(bitand(u.protocol, 1), 0, 'NO  ', 1, 'YES ') http_enabled, decode(bitand(u.protocol, 2), 0, 'NO  ', 2, 'YES ') smtp_enabled FROM SYSTEM.AQ$_Internet_Agents u

View Text - HTML Formatted

SELECT U.AGENT_NAME
, DECODE(BITAND(U.PROTOCOL
, 1)
, 0
, 'NO '
, 1
, 'YES ') HTTP_ENABLED
, DECODE(BITAND(U.PROTOCOL
, 2)
, 0
, 'NO '
, 2
, 'YES ') SMTP_ENABLED
FROM SYSTEM.AQ$_INTERNET_AGENTS U