Solution for WMSYS. WM_CONCAT in oracle not found in 12c

WMSYS. WM_CONCAT does not appear in 12c because WMSYS. WM_CONCAT is an oracle supported internal function that is included in the oracle workspace manager component (wmsys user). This function is used internally by for workspace manager.

This means that it is not recommended for general applications to call this function, because this function may be due to version upgrades or performance optimization and other reasons, oracle developers can modify or cancel this function without notifying users.

Therefore, it is not recommended to use this function in the application. After 11.2, you can use the listparts function.

For details, see WMSYS. WM_CONCAT shocould Not Be Used For Customer Applications, It Is An Internal Function (Doc ID 1336219.1)

10g:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
SQL> select owner, object_name, object_type from dba_objects where object_name = 'wm _ concat ';
 
OWNER OBJECT_NAME OBJECT_TYPE
--------------------------------------------------------------------------------
PUBLIC WM_CONCAT SYNONYM
WMSYS WM_CONCAT FUNCTION
 
SQL>
 
 
11g:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
SQL> select owner, object_name, object_type from dba_objects where object_name = 'wm _ concat ';
 
OWNER OBJECT_NAME OBJECT_TYPE
--------------------------------------------------------------------------------
PUBLIC WM_CONCAT SYNONYM
WMSYS WM_CONCAT FUNCTION
 
SQL>
 
 
12c:
Connected:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
 
SQL> select owner, object_name, object_type from dba_objects where object_name = 'wm _ concat ';
 
No rows selected
 
SQL>