calculating variables in sql script

From: <samir.vds_at_googlemail.com>
Date: 22 Mar 2007 03:45:33 -0700
Message-ID: <1174560333.676752.78370@l77g2000hsb.googlegroups.com>

Hey guys,

I've this SQL script, which contains 3 insert statements. As you can see in the first statement takes data from table MC
$TA_F_VVL_KMP_200604. In the 2nd statement it takes data from table MC
$TA_F_VVL_KMP_200605 and in the 3rd one from table MC
$TA_F_VVL_KMP_200606. So basically it is doing +1, +2 ...
Is there a way I can automatically calculate that in order to automatize the script? SQL scripts doesn't seem to be capable of calculating variables. If that is so, is there some other scripting/ programming language available in which I can accomplish this?

I'd be very grateful for any suggestions, regards Samir

Code:
insert into SARIKAYA.MC$TA_H_VVL_KAMP_MORPU_200604(DWH_VERTRAG_ID, QUELLTARIF_ID, ZIELTARIF_ID, CCOS_OFFER_FOLDER_ID, BERICHTSMONAT, DATENMONAT, VERTRAGSBEGINN_M, RAHMENVERTRAG, ERLOES_NETTO_EURO, VW_KENN, KKM_KAMPAGNE_ID, KKM_ANTWORTTYP_ID)

SELECT	/*+parallel (T1,4)*/T2.DWH_VERTRAG_ID,
	T2.QUELLTARIF_ID,
	T2.ZIELTARIF_ID,
	T2.CCOS_OFFER_FOLDER_ID,
	to_number(to_char(T2.VVL_STICHTAG, 'YYYYMM')),
	T1.Monats_ID,
	T1.VERTRAGSBEGINN_M,
	T1.RAHMENVERTRAG,
	sum(T1.ERLOES_NETTO_CENT)/100,
	T2.VW_KENN,
	T2.KKM_KAMPAGNE_ID,
	T2.KKM_ANTWORTTYP_ID
FROM DW_HOUSE_SCHEMA.DWH$TA_F_MORPU_VERTRAG T1,
	MC$TA_F_VVL_KMP_200604 T2

where T1.DWH_VERTRAG_ID = T2.DWH_VERTRAG_ID and T1.MONATS_ID = &1
group by T2.DWH_VERTRAG_ID, T2.QUELLTARIF_ID, T2.ZIELTARIF_ID, T2.CCOS_OFFER_FOLDER_ID, to_number(to_char(T2.VVL_STICHTAG, 'YYYYMM')), T1.Monats_ID, T1.VERTRAGSBEGINN_M, T1.VO_KENN, T1.RAHMENVERTRAG, VW_KENN, KKM_KAMPAGNE_ID, KKM_ANTWORTTYP_ID; commit;

insert into SARIKAYA.MC$TA_H_VVL_KAMP_MORPU_200605(DWH_VERTRAG_ID, QUELLTARIF_ID, ZIELTARIF_ID, CCOS_OFFER_FOLDER_ID, BERICHTSMONAT, DATENMONAT, VERTRAGSBEGINN_M, RAHMENVERTRAG, ERLOES_NETTO_EURO, VW_KENN, KKM_KAMPAGNE_ID, KKM_ANTWORTTYP_ID)

SELECT	/*+parallel (T1,4)*/T2.DWH_VERTRAG_ID,
	T2.QUELLTARIF_ID,
	T2.ZIELTARIF_ID,
	T2.CCOS_OFFER_FOLDER_ID,
	to_number(to_char(T2.VVL_STICHTAG, 'YYYYMM')),
	T1.Monats_ID,
	T1.VERTRAGSBEGINN_M,
	T1.RAHMENVERTRAG,
	sum(T1.ERLOES_NETTO_CENT)/100,
	T2.VW_KENN,
	T2.KKM_KAMPAGNE_ID,
	T2.KKM_ANTWORTTYP_ID
FROM DW_HOUSE_SCHEMA.DWH$TA_F_MORPU_VERTRAG T1,
	MC$TA_F_VVL_KMP_200605 T2

where T1.DWH_VERTRAG_ID = T2.DWH_VERTRAG_ID and T1.MONATS_ID = &1
group by T2.DWH_VERTRAG_ID, T2.QUELLTARIF_ID, T2.ZIELTARIF_ID, T2.CCOS_OFFER_FOLDER_ID, to_number(to_char(T2.VVL_STICHTAG, 'YYYYMM')), T1.Monats_ID, T1.VERTRAGSBEGINN_M, T1.VO_KENN, T1.RAHMENVERTRAG, VW_KENN, KKM_KAMPAGNE_ID, KKM_ANTWORTTYP_ID; commit;

insert into SARIKAYA.MC$TA_H_VVL_KAMP_MORPU_200606(DWH_VERTRAG_ID, QUELLTARIF_ID, ZIELTARIF_ID, CCOS_OFFER_FOLDER_ID, BERICHTSMONAT, DATENMONAT, VERTRAGSBEGINN_M, RAHMENVERTRAG, ERLOES_NETTO_EURO, VW_KENN, KKM_KAMPAGNE_ID, KKM_ANTWORTTYP_ID)

SELECT	/*+parallel (T1,4)*/T2.DWH_VERTRAG_ID,
	T2.QUELLTARIF_ID,
	T2.ZIELTARIF_ID,
	T2.CCOS_OFFER_FOLDER_ID,
	to_number(to_char(T2.VVL_STICHTAG, 'YYYYMM')),
	T1.Monats_ID,
	T1.VERTRAGSBEGINN_M,
	T1.RAHMENVERTRAG,
	sum(T1.ERLOES_NETTO_CENT)/100,
	T2.VW_KENN,
	T2.KKM_KAMPAGNE_ID,
	T2.KKM_ANTWORTTYP_ID
FROM DW_HOUSE_SCHEMA.DWH$TA_F_MORPU_VERTRAG T1,
	MC$TA_F_VVL_KMP_200606 T2

where T1.DWH_VERTRAG_ID = T2.DWH_VERTRAG_ID and T1.MONATS_ID = &1
group by T2.DWH_VERTRAG_ID, T2.QUELLTARIF_ID, T2.ZIELTARIF_ID, T2.CCOS_OFFER_FOLDER_ID, to_number(to_char(T2.VVL_STICHTAG, 'YYYYMM')), T1.Monats_ID, T1.VERTRAGSBEGINN_M, T1.VO_KENN, T1.RAHMENVERTRAG, VW_KENN, KKM_KAMPAGNE_ID, KKM_ANTWORTTYP_ID; commit; Received on Thu Mar 22 2007 - 05:45:33 CDT