The 11gR2 new analytic function LISTAGG is not recognised by syntax checker.
For example:
SELECT deptno,
AVG (sal) avg_sal,
listagg (ename, ,) WITHIN GROUP (ORDER BY sal) enames
FROM emp
GROUP BY deptno
The code above runs ok but if we try to format it, the following error message appears:
ERROR line 4, col 10, ending_line 4, ending_col 16, Found listagg, Only CUME_DIST, DENSE_RANK, PERCENT_RANK, RANK, PERCENTILE_CONT and PERCENTILE_DISC are valid with WITHIN GROUP
The parser in version 10.1 does not support this 11gR2 function
Toad for Oracle 11.0 and above support this. You can download the latest version of Toad using
