[Home] [Help] [Dependency Information]
Object Name: | AQ$_XDP_FA_QTAB_F |
---|---|
Object Type: | VIEW |
Owner: | XDP |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
Q_NAME | VARCHAR2 | (30) | ||
ROW_ID | ROWID | (10) | ||
MSGID | RAW | (16) | Yes | |
CORRID | VARCHAR2 | (128) | ||
PRIORITY | NUMBER | |||
STATE | NUMBER | |||
DELAY | TIMESTAMP(6) | (20) | ||
EXPIRATION | NUMBER | |||
ENQ_TIME | TIMESTAMP(6) | (20) | ||
ENQ_UID | NUMBER | |||
ENQ_TID | VARCHAR2 | (30) | ||
DEQ_TIME | TIMESTAMP(6) | (20) | ||
DEQ_UID | NUMBER | |||
DEQ_TID | VARCHAR2 | (30) | ||
RETRY_COUNT | NUMBER | |||
EXCEPTION_QSCHEMA | VARCHAR2 | (30) | ||
EXCEPTION_QUEUE | VARCHAR2 | (30) | ||
CSCN | NUMBER | |||
DSCN | NUMBER | |||
CHAIN_NO | NUMBER | |||
LOCAL_ORDER_NO | NUMBER | |||
TIME_MANAGER_INFO | TIMESTAMP(6) | (20) | ||
STEP_NO | NUMBER | |||
USER_DATA | XDP_WF_CHANNELQ_TYPE | (472) | ||
SENDER_NAME | VARCHAR2 | (30) | ||
SENDER_ADDRESS | VARCHAR2 | (1024) | ||
SENDER_PROTOCOL | NUMBER | |||
DEQUEUE_MSGID | RAW | (16) | ||
DELIVERY_MODE | CHAR | (10) | ||
SEQUENCE_NUM | NUMBER | |||
MSG_NUM | NUMBER | |||
QUEUE_ID | NUMBER | Yes | ||
USER_PROP | ANYDATA | (4392) |
Cut, paste (and edit) the following text to query this object:
SELECT Q_NAME
, ROW_ID
, MSGID
, CORRID
, PRIORITY
, STATE
, DELAY
, EXPIRATION
, ENQ_TIME
, ENQ_UID
, ENQ_TID
, DEQ_TIME
, DEQ_UID
, DEQ_TID
, RETRY_COUNT
, EXCEPTION_QSCHEMA
, EXCEPTION_QUEUE
, CSCN
, DSCN
, CHAIN_NO
, LOCAL_ORDER_NO
, TIME_MANAGER_INFO
, STEP_NO
, USER_DATA
, SENDER_NAME
, SENDER_ADDRESS
, SENDER_PROTOCOL
, DEQUEUE_MSGID
, DELIVERY_MODE
, SEQUENCE_NUM
, MSG_NUM
, QUEUE_ID
, USER_PROP
FROM XDP.AQ$_XDP_FA_QTAB_F;
XDP.AQ$_XDP_FA_QTAB_F is not referenced by any database object
|
|
|