[Home] [Help] [Dependency Information]
Object Name: | AQ$XNP_IN_TMR_QTAB |
---|---|
Object Type: | VIEW |
Owner: | XNP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QUEUE | VARCHAR2 | (30) | ||
MSG_ID | RAW | (16) | Yes | |
CORR_ID | VARCHAR2 | (128) | ||
MSG_PRIORITY | NUMBER | |||
MSG_STATE | VARCHAR2 | (16) | ||
DELAY | DATE | |||
DELAY_TIMESTAMP | TIMESTAMP(6) | (11) | ||
EXPIRATION | NUMBER | |||
ENQ_TIME | DATE | |||
ENQ_TIMESTAMP | TIMESTAMP(6) | (20) | ||
ENQ_USER_ID | NUMBER | |||
ENQ_TXN_ID | VARCHAR2 | (30) | ||
DEQ_TIME | DATE | |||
DEQ_TIMESTAMP | TIMESTAMP(6) | (20) | ||
DEQ_USER_ID | NUMBER | |||
DEQ_TXN_ID | VARCHAR2 | (30) | ||
RETRY_COUNT | NUMBER | |||
EXCEPTION_QUEUE_OWNER | VARCHAR2 | (30) | ||
EXCEPTION_QUEUE | VARCHAR2 | (30) | ||
USER_DATA | XNP_MESSAGE_TYPE | (48) | ||
ORIGINAL_QUEUE_NAME | VARCHAR2 | (30) | ||
ORIGINAL_QUEUE_OWNER | VARCHAR2 | (30) | ||
EXPIRATION_REASON | VARCHAR2 | (18) | ||
SENDER_NAME | VARCHAR2 | (30) | ||
SENDER_ADDRESS | VARCHAR2 | (1024) | ||
SENDER_PROTOCOL | NUMBER | |||
ORIGINAL_MSGID | RAW | (16) |
Cut, paste (and edit) the following text to query this object:
SELECT QUEUE
, MSG_ID
, CORR_ID
, MSG_PRIORITY
, MSG_STATE
, DELAY
, DELAY_TIMESTAMP
, EXPIRATION
, ENQ_TIME
, ENQ_TIMESTAMP
, ENQ_USER_ID
, ENQ_TXN_ID
, DEQ_TIME
, DEQ_TIMESTAMP
, DEQ_USER_ID
, DEQ_TXN_ID
, RETRY_COUNT
, EXCEPTION_QUEUE_OWNER
, EXCEPTION_QUEUE
, USER_DATA
, ORIGINAL_QUEUE_NAME
, ORIGINAL_QUEUE_OWNER
, EXPIRATION_REASON
, SENDER_NAME
, SENDER_ADDRESS
, SENDER_PROTOCOL
, ORIGINAL_MSGID
FROM XNP.AQ$XNP_IN_TMR_QTAB;
|
|
|