Comparer le texte

Encuentra la diferencia entre dos archivos de texto

Real-time diff
Unified diff
Collapse lines
Highlight change
Syntax highlighting
Outils

Comparing sensitive data, confidential files or internal emails?

Most legal and privacy policies prohibit uploading sensitive data online. Diffchecker Desktop ensures your confidential information never leaves your computer. Work offline and compare documents securely.

Download Diffchecker DesktopLearn more

Untitled diff

Created Diff never expires
10 removals
28 lines
10 additions
28 lines
SELECT T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 2 DEGER_TIPI, T4.ISBIRIMI_SEC_ID ORG_ID, 9 SEVIYE_ID, T4.MIY_SEGMENT_KODU, -1 MBB_SEGMENT_KODU, 2 PARA_BIRIMI, SUM( General Information.Convert_To_TL_AVG ( T1.TARIH, T1.DOVIZ_KODU,( NVL (T1.ORTALAMA_TUTARI, 0)))) AS GERC_MAL_TL
SELECT T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 1 DEGER_TIPI, T4.ISBIRIMI_SEC_ID ORG_ID, 9 SEVIYE_ID, T4.MIY_SEGMENT_KODU, -1 MBB_SEGMENT_KODU, 2 PARA_BIRIMI, SUM( General Information.Convert_To_TL ( T1.TARIH, T1.DOVIZ_KODU,( NVL (T1.NOKTA_BAKIYE_TUMU, 0)))) AS GERC_MAL_TL
FROM PARG.ARG_TISTATISTIK_GUNLUK_HSP_MAL T1, PARG.ARG_THESAP_MAL T2, PARG.ARG_TURUN_AGAC_FLAT T3, (SELECT DISTINCT
FROM PARG.ARG_TISTATISTIK_GUNLUK_HSP_MAL T1, PARG.ARG_THESAP_MAL T2, PARG.ARG_TURUN_AGAC_FLAT T3, (SELECT DISTINCT
ISBIRIMI_SEC_ID, MIY_SEGMENT_KODU
ISBIRIMI_SEC_ID, MIY_SEGMENT_KODU
FROM PARG_MART.DIM_ORGANIZASYON_HIYERARSI
FROM PARG_MART.DIM_ORGANIZASYON_HIYERARSI
WHERE 'p_Last_Day_of_Month' BETWEEN BASLANGIC_TARIHI AND BITIS_TARIHI) T4
WHERE 'p_Last_Day_of_Month' BETWEEN BASLANGIC_TARIHI AND BITIS_TARIHI) T4
WHERE T1.HESAP_ID = T2.HESAP_ID
WHERE T1.HESAP_ID = T2.HESAP_ID
AND T1.URUN_ID = T3.URUN_ID
AND T1.URUN_ID = T3.URUN_ID
AND (case when T2.MIY_SEGMENT_KODU IN (100,200,800) then T2.MIY_SEGMENT_KODU else 600 end )= T4.MIY_SEGMENT_KODU
AND (case when T2.MIY_SEGMENT_KODU IN (100,200,800) then T2.MIY_SEGMENT_KODU else 600 end )= T4.MIY_SEGMENT_KODU
AND T4.MIY_SEGMENT_KODU IN (100,200,800,600)
AND T4.MIY_SEGMENT_KODU IN (100,200,800,600)
AND T3.URUN_SEVIYE4_ID IN '&PDWH URUN_ID'
AND T3.URUN_SEVIYE4_ID IN '&PDWH URUN_ID'
AND T1.FREKANS_ID = 3
AND T1.FREKANS_ID = 1
AND T1.TARIH = 'p_Last_Day_of_Month'
AND T1.TARIH = 'p_Last_Day_of_Month'
GROUP BY T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 2, T4.ISBIRIMI_SEC_ID, 9 , T4.MIY_SEGMENT_KODU, -1, 1
GROUP BY T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 1, T4.ISBIRIMI_SEC_ID, 9 , T4.MIY_SEGMENT_KODU, -1, 1
UNION
UNION
SELECT T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 2 DEGER_TIPI, T4.ISBIRIMI_SEC_ID ORG_ID, 9 SEVIYE_ID, T4.MIY_SEGMENT_KODU, -1 MBB_SEGMENT_KODU, 2 PARA_BIRIMI, SUM( General Information.Convert_To_TL_AVG ( T1.TARIH, T1.DOVIZ_KODU,( NVL (T1.ORTALAMA_TUTARI, 0)))) AS GERC_MAL_TL
SELECT T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 1 DEGER_TIPI, T4.ISBIRIMI_SEC_ID ORG_ID, 9 SEVIYE_ID, T4.MIY_SEGMENT_KODU, -1 MBB_SEGMENT_KODU, 2 PARA_BIRIMI, SUM( General Information.Convert_To_TL ( T1.TARIH, T1.DOVIZ_KODU,( NVL (T1.NOKTA_BAKIYE_TUMU, 0)))) AS GERC_MAL_TL
FROM PARG.ARG_TISTATISTIK_GUNLUK_HSP_DWH T1, PARG.ARG_THESAP_DWH T2, PARG.ARG_TURUN_AGAC_FLAT T3, (SELECT DISTINCT
FROM PARG.ARG_TISTATISTIK_GUNLUK_HSP_DWH T1, PARG.ARG_THESAP_DWH T2, PARG.ARG_TURUN_AGAC_FLAT T3, (SELECT DISTINCT
ISBIRIMI_SEC_ID, MIY_SEGMENT_KODU
ISBIRIMI_SEC_ID, MIY_SEGMENT_KODU
FROM PARG_MART.DIM_ORGANIZASYON_HIYERARSI
FROM PARG_MART.DIM_ORGANIZASYON_HIYERARSI
WHERE 'p_Last_Day_of_Month' BETWEEN BASLANGIC_TARIHI AND BITIS_TARIHI) T4
WHERE 'p_Last_Day_of_Month' BETWEEN BASLANGIC_TARIHI AND BITIS_TARIHI) T4
WHERE T1.HESAP_ID = T2.HESAP_ID
WHERE T1.HESAP_ID = T2.HESAP_ID
AND T1.URUN_ID = T3.URUN_ID
AND T1.URUN_ID = T3.URUN_ID
AND (case when T2.MIY_SEGMENT_KODU IN (100,200,800) then T2.MIY_SEGMENT_KODU else 600 end )= T4.MIY_SEGMENT_KODU
AND (case when T2.MIY_SEGMENT_KODU IN (100,200,800) then T2.MIY_SEGMENT_KODU else 600 end )= T4.MIY_SEGMENT_KODU
AND T4.MIY_SEGMENT_KODU IN (100,200,800,600)
AND T4.MIY_SEGMENT_KODU IN (100,200,800,600)
AND T3.URUN_SEVIYE4_ID IN '&PDWH URUN_ID'
AND T3.URUN_SEVIYE4_ID IN '&PDWH URUN_ID'
AND T1.FREKANS_ID = 3
AND T1.FREKANS_ID = 1
AND T1.TARIH = 'p_Last_Day_of_Month'
AND T1.TARIH = 'p_Last_Day_of_Month'
AND T2.HESAP_ACILIS_SUBE_ALT_KANAL_ID=649
AND T2.HESAP_ACILIS_SUBE_ALT_KANAL_ID=649
GROUP BY T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 2, T4.ISBIRIMI_SEC_ID, 9 , T4.MIY_SEGMENT_KODU, -1, 1
GROUP BY T1.TARIH, '&FACT_BUTCE_GERC_KREDI_MIYSGMNT.KPI_ID', 1, T4.ISBIRIMI_SEC_ID, 9 , T4.MIY_SEGMENT_KODU, -1, 1
Les différences enregistrées