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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

String Aggregation with CLOB type

975959Jan 5 2013 — edited Jan 6 2013

Hi,
I should compare to query result from two different DB version: Oracle 11.1 and 11.2.
What I'd like to perform is a string aggregation. I read for 11.2 there is LISTAGG function, while for 11.1 I could use WMSYS.WMCONCAT.

A doubt is that I should aggregate CLOB type. Is it possible, or are there any limitations for the above functions?

Many thanks,
Ste

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 3 2013

Added on Jan 5 2013

5 comments

7,254 views