RIB - Extract a payload from a Oracle Queue

English Version

Neste post partilho uma a query usada para extratir o mensagens de systemas Oracle AQ queues/topicos.

set lines 300
col enq_time  form a30
col deq_time form a10
col msg form a100
set longchunksize 30000
set long 30000

select msgid,enq_time, deq_time, r.user_data.text_lob msg
 from ribaq.etitemsfromrmstable r
 where
 enq_time > sysdate - 1
 and r.user_data.text_lob  like '%101715654%'
 order by enq_time;

Obrigado pela leitura, espero que este post o tenha ajudado.

Versao Portuguesa

In post I'm shared a query I used to run to see payload messages in  Oracle AQ queues / topics . 

set lines 300

col enq_time  form a30

col deq_time form a10

col msg form a100

set longchunksize 30000

set long 30000

select msgid,enq_time, deq_time, r.user_data.text_lob msg

 from ribaq.etitemsfromrmstable r

 where

 enq_time > sysdate - 1

 and r.user_data.text_lob  like '%101715654%'

 order by enq_time;

Thank you for reading, hope this post was helpful.