on Toad for Oracle 220.127.116.11 32bit I have the following behaviour which I believe is a bug:
- Execute the following example in an editor (F9)
LISTAGG(DUMMY, ‘,’) WITHIN GROUP (ORDER BY DUMMY) DUMMYLIST
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.