SELECT queue_name QUEUE, name NAME , address ADDRESS , protocol PROTOCOL, trans_name TRANSFORMATION, decode(bitand(SUBSCRIBER_TYPE, 512), 512, 'TRUE', 'FALSE') QUEUE_TO_QUEUE FROM "AQ$_WF_WS_SAMPLE_S" s WHERE (bitand(s.subscriber_type, 1) = 1) WITH READ ONLY
SELECT QUEUE_NAME QUEUE
, NAME NAME
, ADDRESS ADDRESS
, PROTOCOL PROTOCOL
, TRANS_NAME TRANSFORMATION
, DECODE(BITAND(SUBSCRIBER_TYPE
, 512)
, 512
, 'TRUE'
, 'FALSE') QUEUE_TO_QUEUE
FROM "AQ$_WF_WS_SAMPLE_S" S
WHERE (BITAND(S.SUBSCRIBER_TYPE
, 1) = 1) WITH READ ONLY
|
|
|