mydev> select
2 substr(zahldatum,1,6) as "JJJJMM",
3 rtrim(substrb(codebudget,1,20)) "Budget",
4 decode(zahltyp,'C', TO_NUMBER(sum(betrag) / 100 )) as "HABEN",
5 decode(zahltyp,'D', TO_NUMBER(sum(betrag) / 100 )) as "SOLL"
6 from tab1
7 where substr(zahldatum,1,4) = '2006'
8 group by substr(zahldatum,1,6), substrb(codebudget,1,20), zahltyp;
JJJJMM Budget HABEN SOLL
------------------ ----------- --------------- ---------------
200604 Mein Budg 152,3
****************** *********** --------------- ---------------
Summe: 152,3
200605 Me122Budget 1000,35
200605 Mein Budget 1560,25
****************** *********** --------------- ---------------
Summe: 1560,25 1000,35
3 Zeilen ausgewõhlt.
mydev> alter session set nls_numeric_characters = '.''';
Session wurde geõndert.
mydev> COL HABEN ON FORMAT 999G990D00
mydev> COL SOLL ON FORMAT 999G990D00
mydev> select
2 substr(zahldatum,1,6) as "JJJJMM",
3 rtrim(substrb(codebudget,1,20)) "Budget",
4 decode(zahltyp,'C', TO_NUMBER(sum(betrag) / 100 )) as "HABEN",
5 decode(zahltyp,'D', TO_NUMBER(sum(betrag) / 100 )) as "SOLL"
6 from tab1
7 where substr(zahldatum,1,4) = '2006'
8 group by substr(zahldatum,1,6), substrb(codebudget,1,20), zahltyp;
JJJJMM Budget HABEN SOLL
------------------ ----------- ----------- -----------
200604 Mein Budg 152.30
****************** *********** ----------- -----------
Summe: 152.30
200605 Me122Budget 1'000.35
200605 Mein Budget 1'560.25
****************** *********** ----------- -----------
Summe: 1'560.25 1'000.35
3 Zeilen ausgewõhlt.