Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 11.2]
Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 12.1]
Workspace Manager - Version 188.8.131.52 to 184.108.40.206 [Release 9.2 to 11.2]
Oracle Spatial and Graph - Version 220.127.116.11 to 18.104.22.168 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 17-Dec-2012***
This document is meant to assist both Customers and Oracle Support Analysts in handling situations and Service Requests in which the problem is related to the usage of the undocumented function WMSYS.WM_CONCAT.
WMSYS.WM_CONCAT function is used internally and for this reason it is UN-documented.
Oracle Development uses internal procedure/functions like WMSYS.WM_CONCAT to support Oracle products.
Oracle suggests that customers do not use internal objects, procedures, data dictionary tables in their applications because they may be changed at any time.
If Oracle Development needs to change this function, to correct a bug or enhance performances, they make all the changes internally and the changes are NOT published.
Any non-Oracle document found on Internet referring to this function is not reliable. Anything Oracle does support, is documented in our guides and/or published documents searchable on MyOracle Support.
It should be relatively straightforward for a developer to create an aggregate function similar to WMSYS.WM_CONCAT.
Some useful links that can be used to understand how to proceed are:
Additionally, from 11.2 release onwards it might be a good idea that of using for this same purpose the analytics function named LISTAGG.
You can find a reference ans some good example inthe following documentation: