Difference between revisions of "IX.ORDERS QUEUETABLE (table)"

From dbscript Online Help
Jump to: navigation, search
(Replacing page with '== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''table | IX.ORDERS_QUEUETABLE |- |}')
 
(3 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
−
|-
+
|- valign="top"
−
| '''table
+
| '''Table
 
| IX.ORDERS_QUEUETABLE
 
| IX.ORDERS_QUEUETABLE
−
|-
+
|}
 +
 
 +
=== Columns ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Column
 +
| '''Data Type
 +
| '''Nullable
 +
| '''Default
 +
| '''Description
 +
 
 +
|- valign="top"
 +
| Q_NAME
 +
| VARCHAR2(30)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| MSGID
 +
| RAW(16)
 +
| not null
 +
|
 +
|
 +
|- valign="top"
 +
| CORRID
 +
| VARCHAR2(128)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| PRIORITY
 +
| NUMBER
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| STATE
 +
| NUMBER
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| DELAY
 +
| TIMESTAMP(6)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| EXPIRATION
 +
| NUMBER
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| TIME_MANAGER_INFO
 +
| TIMESTAMP(6)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| LOCAL_ORDER_NO
 +
| NUMBER
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| CHAIN_NO
 +
| NUMBER
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| CSCN
 +
| NUMBER
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| DSCN
 +
| NUMBER
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| ENQ_TIME
 +
| TIMESTAMP(6)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| ENQ_UID
 +
| VARCHAR2(30)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| ENQ_TID
 +
| VARCHAR2(30)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| DEQ_TIME
 +
| TIMESTAMP(6)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| DEQ_UID
 +
| VARCHAR2(30)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| DEQ_TID
 +
| VARCHAR2(30)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| RETRY_COUNT
 +
| NUMBER
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| EXCEPTION_QSCHEMA
 +
| VARCHAR2(30)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| EXCEPTION_QUEUE
 +
| VARCHAR2(30)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| STEP_NO
 +
| NUMBER
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| RECIPIENT_KEY
 +
| NUMBER
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| DEQUEUE_MSGID
 +
| RAW(16)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| SENDER_NAME
 +
| VARCHAR2(30)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| SENDER_ADDRESS
 +
| VARCHAR2(1024)
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| SENDER_PROTOCOL
 +
| NUMBER
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| USER_DATA
 +
| IX.ORDER_EVENT_TYP
 +
| null
 +
|
 +
|
 +
|- valign="top"
 +
| USER_PROP
 +
| SYS.ANYDATA
 +
| null
 +
|
 +
|
 +
|}
 +
 
 +
=== Primary Key ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|- valign="top"
 +
| SYS_C005059
 +
| MSGID
 
|}
 
|}

Latest revision as of 11:34, 27 August 2011

wikibot[edit]

Table IX.ORDERS_QUEUETABLE

Columns[edit]

Column Data Type Nullable Default Description
Q_NAME VARCHAR2(30) null
MSGID RAW(16) not null
CORRID VARCHAR2(128) null
PRIORITY NUMBER null
STATE NUMBER null
DELAY TIMESTAMP(6) null
EXPIRATION NUMBER null
TIME_MANAGER_INFO TIMESTAMP(6) null
LOCAL_ORDER_NO NUMBER null
CHAIN_NO NUMBER null
CSCN NUMBER null
DSCN NUMBER null
ENQ_TIME TIMESTAMP(6) null
ENQ_UID VARCHAR2(30) null
ENQ_TID VARCHAR2(30) null
DEQ_TIME TIMESTAMP(6) null
DEQ_UID VARCHAR2(30) null
DEQ_TID VARCHAR2(30) null
RETRY_COUNT NUMBER null
EXCEPTION_QSCHEMA VARCHAR2(30) null
EXCEPTION_QUEUE VARCHAR2(30) null
STEP_NO NUMBER null
RECIPIENT_KEY NUMBER null
DEQUEUE_MSGID RAW(16) null
SENDER_NAME VARCHAR2(30) null
SENDER_ADDRESS VARCHAR2(1024) null
SENDER_PROTOCOL NUMBER null
USER_DATA IX.ORDER_EVENT_TYP null
USER_PROP SYS.ANYDATA null

Primary Key[edit]

Primary Key Columns
SYS_C005059 MSGID
Retrieved from "http://dbshelp.devio.at/index.php?title=IX.ORDERS_QUEUETABLE_(table)&oldid=3062"