Devart Forums

Code: Select all

        SELECT inl.Quelle, inl.Technik, inl.Netzelement, ROUND(AVG(inl.duration_in_sec), 1) Laufzeit_in_Sek, count(1) ANZAHL
          FROM
              (
               SELECT two.orig_login Quelle,
                      DECODE(thc.tech_type, 'JINTERP', 'EWSD', thc.tech_type) Technik,
                      ts.host_clli Netzelement,
                      (SYSDATE - two.start_dts) * 24 * 60 * 60 duration_in_sec
                 FROM tbl_wrk_ord two
                      INNER JOIN tbl_srq ts        ON (two.srq_id    = ts.srq_id   )
                      INNER JOIN tbl_host_clli thc ON (thc.host_clli = ts.host_clli)
                WHERE 1 = 1
                  AND two.wo_stat   = 103
                  AND two.orig_login IN ('TTT', 'PBOX')
              ) inl
         GROUP BY Quelle, Technik, Netzelement

Code: Select all

SELECT  QUELLE WERT_DETAIL_1,
        TECHNIK WERT_DETAIL_2,
        NETZELEMENT WERT_DETAIL_3,
        NULL WERT_DETAIL_4,
        Laufzeit_in_Sek WERT_VALUE_NUMBER_1,
        ANZAHL WERT_VALUE_NUMBER_2,
        NULL WERT_VALUE_NUMBER_3,
        NULL WERT_VALUE_NUMBER_4,
        NULL WERT_VALUE_NUMBER_5,
        NULL WERT_VALUE_VARCHAR2_1,
        NULL WERT_VALUE_VARCHAR2_2,
        NULL WERT_VALUE_VARCHAR2_3,
        NULL WERT_VALUE_VARCHAR2_4,
        NULL WERT_VALUE_VARCHAR2_5,
        NULL WERT_VALUE_DATE_1,
        NULL WERT_VALUE_DATE_2,
        NULL WERT_VALUE_DATE_3,
        NULL WERT_VALUE_DATE_4,
        NULL WERT_VALUE_DATE_5,
        NULL WERT_FLAG 
  FROM ( 
        SELECT inl.Quelle, inl.Technik, inl.Netzelement, ROUND(AVG(inl.duration_in_sec), 1) Laufzeit_in_Sek, count(1) ANZAHL
          FROM
              (
               SELECT two.orig_login Quelle,
                      DECODE(thc.tech_type, 'JINTERP', 'EWSD', thc.tech_type) Technik,
                      ts.host_clli Netzelement,
                      (SYSDATE - two.start_dts) * 24 * 60 * 60 duration_in_sec
                 FROM tbl_wrk_ord two
                      INNER JOIN tbl_srq ts        ON (two.srq_id    = ts.srq_id   )
                      INNER JOIN tbl_host_clli thc ON (thc.host_clli = ts.host_clli)
                WHERE 1 = 1
                  AND two.wo_stat   = 103
                  AND two.orig_login IN ('TTT', 'PBOX')
              ) inl
         GROUP BY Quelle, Technik, Netzelement
       )