Toad World® Forums

Toad Formatter Bug - - Unpivot followed by Pivot not recognized.

When a Pivot clause is used immediately after an unpivot, the formatter doesn’t recognize as valid syntax and returns an error. This is demonstrated in the following simple example.

Select * From Dual Unpivot (c For d In (dummy As 'Unpivot')) pivot (Max(c) For d in ('Unpivot'));

If an attempt to format the above is made in then it fails. However the code runs fine.

Thanks, this is logged.