IX AQ$STREAMS_QUEUE_TABLE (view)

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

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''View'''
| IX.AQ$STREAMS_QUEUE_TABLE
|}

=== Source ===
{{{{<nowiki>
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')
            
</nowiki>}}}}

devio dbscript ScrewTurn Wiki

Navigation¶

IX AQ$STREAMS_QUEUE_TABLE (view)