Skip to content
Skip to breadcrumbs
Skip to header menu
Skip to action menu
Skip to quick search

Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

Code Block

language	sql
title	Список сообщений во входящей очереди

SELECT    I.ENQ_TIME + 3/24,
          I.DEQ_TIME + 3/24,
          I.CEIL(DEQ_TIME - I.ENQ_TIME) PROC_DURATION_SEC,
         MSG_STATE,
         NVL(I.USER_DATA.TEXT_LOB, I.USER_DATA.TEXT_VC) MESSAGE
FROM      AQAQ$AQ_IN_HYDRA_SYS I
ORDER BY  I.ENQ_TIME;
/