When the following SELECT is entered into Toad For Oracle 12.10 returns an error even if the query is correct and returns the valid result:
SELECT *
FROM (SELECT 'A' x, '1' y FROM DUAL UNION
SELECT 'A' x, '2' y FROM DUAL UNION
SELECT 'B' x, '1' y FROM DUAL UNION
SELECT 'B' x, '2' y FROM DUAL) PIVOT (LISTAGG (y, ',') within GROUP (ORDER BY y) for x in ('A' as A, 'B' as B))
The error is: [Error] Syntax check (10: 42):
WORKAROUND:
None
SOLUTION:
Issue fixed in version 12.11. The latest version of Toad for Oracle can be downloaded here.