🏠 Menú principal

← Volver a vistas simples

---

LACLS.LACLS_CO_LOGS_MONITORING_V

Base de datos origen: PDB1

Tipo de objeto: VIEW

SQL

  CREATE OR REPLACE FORCE EDITIONABLE VIEW "LACLS"."LACLS_CO_LOGS_MONITORING_V" ("NAME_FLOW", "DESCRIPTION", "LAST_UPDATED_BY", "START_DATE", "END_DATE", "INSTANCE_ID", "STATUS") AS 
  SELECT 
/* $Header: LACLS_CO_LOGS_MONITORING_V.vw 11.1.1113.5 2021/14/01 16:40:30 JFORERO noship $ */
    DISTINCT NAME_FLOW, DESCRIPTION,
       LAST_UPDATED_BY,
--       START_DATE,
       (select MIN(m2.START_DATE)
      from lacls_co_logs_monitoring m2
      where m2.INSTANCE_ID = m.INSTANCE_ID
        and rownum <=1) START_DATE,
/*       (select MAX(m2.LAST_UPDATE_DATE)
      from lacls_co_logs_monitoring m2
      where m2.INSTANCE_ID = m.INSTANCE_ID
        and rownum <=1) END_DATE,*/
      LAST_UPDATE_DATE END_DATE,
       INSTANCE_ID,
       NVL((select m2.status
      from lacls_co_logs_monitoring m2
      where m2.INSTANCE_ID = m.INSTANCE_ID
        and m2.STATUS = 'ERROR'
        and rownum <=1),'SUCCESS') STATUS
from lacls_co_logs_monitoring m
order by LAST_UPDATE_DATE DESC;

---

← Volver al esquema LACLS

🏠 Volver al menú principal