Hi,
on Toad for Oracle 12.5.0.99 32bit I have the following behaviour which I believe is a bug:
- Execute the following example in an editor (F9)
SELECT DUMMY,
LISTAGG(DUMMY, ‘,’) WITHIN GROUP (ORDER BY DUMMY) DUMMYLIST
FROM DUAL
GROUP BY DUMMY;
- Click on one of the result columns and sort the result.
This results in a ORA-30491: ORDER BY-Klausel fehlt (missing ORDER BY clause).
I assume that Toad removes the order by in the aggregation function before appending its own at the end of the statement.
Regards Nick