Difference between revisions of "IX.AQ$ORDERS QUEUETABLE (view)"
Line 10: | Line 10: | ||
<pre> | <pre> | ||
− | CREATE OR REPLACE SELECT q_name QUEUE, qt.msgid MSG_ID, corrid CORR_ID, priority MSG_PRIORITY, decode(h.dequeue_time, NULL, | + | CREATE OR REPLACE VIEW IX.AQ$ORDERS_QUEUETABLE AS |
+ | SELECT q_name QUEUE, qt.msgid MSG_ID, corrid CORR_ID, priority MSG_PRIORITY, decode(h.dequeue_time, NULL, | ||
(decode(state, 0, 'READY', | (decode(state, 0, 'READY', | ||
1, 'WAIT', | 1, 'WAIT', |
Revision as of 20:09, 24 August 2009
wikibot
view | IX.AQ$ORDERS_QUEUETABLE |
CREATE OR REPLACE VIEW IX.AQ$ORDERS_QUEUETABLE AS SELECT q_name QUEUE, qt.msgid MSG_ID, corrid CORR_ID, priority MSG_PRIORITY, decode(h.dequeue_time, NULL, (decode(state, 0, 'READY', 1, 'WAIT', 2, 'PROCESSED', 3, 'EXPIRED', 8, 'DEFERRED')), (decode(h.transaction_id, NULL, 'UNDELIVERABLE', 'PROCESSED'))) MSG_STATE, cast(FROM_TZ(qt.delay, '-08:00') at time zone sessiontimezone as date) delay, delay DELAY_TIMESTAMP, expiration, cast(FROM_TZ(qt.enq_time, '-08:00') at time zone sessiontimezone as date) enq_time, cast(FROM_TZ(qt.enq_time, '-08:00') at time zone sessiontimezone as timestamp) enq_timestamp, enq_uid ENQ_USER_ID, enq_tid ENQ_TXN_ID, decode(h.transaction_id, NULL, TO_DATE(NULL), cast(FROM_TZ(h.dequeue_time, '-08:00')