Skip to Main Content

APEX

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!

listagg query working in Live SQL but not in Apex's SQL Command Window

SmithJohn45Dec 15 2021 — edited Oct 21 2022

please refer to my topic in SQL and PL/SQL Forum
how to concate with listagg with new line feed (0 Bytes)how i can achieve the desired result.
additionally, also created a function but when executing function its throwing another error...
ORA-22905: cannot access rows from a non-nested table item
please help.
regards

This post has been answered by jariola on Dec 15 2021
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 18 2022
Added on Dec 15 2021
7 comments
431 views