Parser fails when || occures in GROUP BY.
Status: Alpha
Brought to you by:
gkello
Example SQL:
SELECT
COUNT(A.KUNDENR||' '||A.KONTRAKTNR) Antall
,C.RESEPTID||' '||C.RESEPTNAMN Tariff
,SUM(D.VFBMENGDE) "Venta forbruk"
FROM
KUNDE.EKKONTRAKTHIST B
,KUNDE.EKRESEPT C
,KUNDE.EKKONTRAKT A
,FELLES.V_EFVENTAFORBRUK D
WHERE
(B.KONTRAKTNR = A.KONTRAKTNR)
AND (B.KUNDENR = A.KUNDENR)
AND (C.RESEPTNR = B.RESEPTNR)
AND A.MAALEPKTNR = D.MAALEPKTNR
AND D.TELLEVERKARTNR = 1
AND D.VFBTILDATO = TO_DATE('01.06.2073','DD.MM.
YYYY')
and (a.valstatus = 'A')
and (b.tarfradato < sysdate)
and (b.tartildato >sysdate)
GROUP BY
C.RESEPTID||' '||C.RESEPTNAMN
,a.valstatus
ORDER BY
C.RESEPTID||' '||C.RESEPTNAMN
,a.valstatus