[Home] [Help]
View: OKC_QUE_NAMES_V
View Text
SELECT QID
, NAME
, QUEUE_TABLE
, QUEUE_TYPE
, OKC_UTIL.DECODE_LOOKUP('OKC_YES_NO'
, RTRIM(LTRIM(ENQUEUE_ENABLED)))
, RTRIM(LTRIM(ENQUEUE_ENABLED))
, OKC_UTIL.DECODE_LOOKUP('OKC_YES_NO'
, RTRIM(LTRIM(DEQUEUE_ENABLED)))
, RTRIM(LTRIM(DEQUEUE_ENABLED))
FROM DBA_QUEUES
WHERE QUEUE_TABLE LIKE 'OKC%'
Columns
Name |
QUEUE_ID |
QUEUE_NAME |
QUEUE_TABLE |
QUEUE_TYPE |
ENQUEUE_ENABLED |
ENQUEUE_ENABLED_CODE |
DEQUEUE_ENABLED |
DEQUEUE_ENABLED_CODE |