Toad World® Forums

Toad Formatter Bug - 12.10.0.30

There appears to be a bug in the Toad Formatter when using the ListAgg() function within a Pivot. The formatter does not recognise that “Within Group” is valid and so fails with syntax check. This can be demonstrated with this simple query.

  Select *
From ( Select 'Cheese' a, Level b
From Dual
Connect By Level <= 5)
Pivot
(Listagg (b) within group (order by 1) for a in ('Cheese'));

The formatting works fine on this statement in the latest beta so I suspect that if you upgrade to 12.11 (when it is released - soon I believe) all will be ok!

Mark.