Schema F_54
Oracle Version 11.2.0.4.0
As Of 2022/09/19 13:58:07
Prior Materialized View | Materialized View MV_PARAM_PARAMETRY_WSZYSTKIE | Next Materialized View |
Table | Query |
---|---|
MV_PARAM_PARAMETRY_WSZYSTKIE | SELECT id, ranking, nazwa_parametru, nazwa_obiektu, typ_obiektu, czy_okreslony_w_czasie, data_od, lead(data_od - interval '1' second) over(partition by id_sl_param_parametr order by data_od) AS data_do, wartosc_number, wartosc_varchar, wartosc_date FROM (SELECT spp.id AS id_sl_param_parametr, pw.id AS id, rank() over (partition BY spp.id order by pw.data_od DESC, pw.id ASC) AS ranking, spp.nazwa AS nazwa_parametru, spo.nazwa AS nazwa_obiektu, spo.typ AS typ_obiektu, spp.czy_okreslony_w_czasie, nvl(pw.data_od, case spp.czy_okreslony_w_czasie when 'T' then utils.data_min end) AS data_od, NVL(pw.wartosc_number , spp.wartosc_number) AS wartosc_number, NVL(pw.wartosc_varchar , spp.wartosc_varchar) AS wartosc_varchar, NVL(pw.wartosc_date , spp.wartosc_date) AS wartosc_date FROM sl_param_parametry spp LEFT JOIN param_wartosci pw ON spp.id = pw.id_sl_param_parametr LEFT JOIN sl_param_obiekty spo ON spo.id = spp.id_sl_param_obiekt ) |