Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

IX AQ$STREAMS_QUEUE_TABLE (view)

RSS
Modified on 2011/08/27 12:09 by wikibot Categorized as Uncategorized

wikibot

ViewIX.AQ$STREAMS_QUEUE_TABLE

Source

CREATE OR REPLACE VIEW IX.AQ$STREAMS_QUEUE_TABLE 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')
            

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.