SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

LISTTAG functionlity in Oracle 10G

BS2012May 13 2013 — edited May 13 2013

Hi Everyone,
I'm using Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit.
Please look at my query and help me out. Will it work for Oracle 10g?

SELECT WEST_TEST_ID, LISTAGG(WEST_TEST_CODE, ',')
WITHIN GROUP (ORDER BY WEST_TEST_CODE) AS test_codes
FROM test_code_conversion
GROUP BY WEST_TEST_ID;
The error I'm getting is ORA-00923 (From keyword not found)

Regards,
BS2012.

This post has been answered by Hoek on May 13 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 10 2013

Added on May 13 2013

4 comments

1,784 views