Difference between revisions of "IX.AQ$ORDERS QUEUETABLE (view)"

From dbscript Online Help
Jump to: navigation, search
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')