Toad World® Forums

LISTAGG not allowed with only one argument

The following query is valid, but gets marked as ERROR: Found ‘)’, Expecting: ,

SELECT LISTAGG( 1 ) WITHIN GROUP( ORDER BY 1 ) FROM dual;

I think this was once before reported as a bug.

could anyone confirmed?

A parser bug indeed.

I didn’t find a record for this defect, but next (or next next) parser version will fix it. (QP-2551)

Thanks,
Andre