根据说明，函数”WMSYS”.”WM_CONCAT”在Oracle 12c中已经被移除了，我们这里的环境是11.2.0.4。以为是手工创建的数据库，所以也没有该函数，如果想继续使用，可以执行如下脚本，创建该函数：

    1. SQL> @?/rdbms/admin/owmctab.plb;
    2. SQL> @?/rdbms/admin/owmaggrs.plb;
    3. SQL> @?/rdbms/admin/owmaggrb.plb;
    4. SQL> @?/rdbms/admin/owmctab.plb;
    5. Function created.
    6. Grant succeeded.
    7. PL/SQL procedure successfully completed.
    8. Grant succeeded.
    9. Procedure created.
    10. Type created.
    11. Type created.
    12. PL/SQL procedure successfully completed.
    13. Table created.
    14. Index created.
    15. Index created.
    16. Table created.
    17. Sequence created.
    18. Table created.
    19. Sequence created.
    20. Table created.
    21. 1 row created.
    22. Commit complete.
    23. Sequence created.
    24. Table created.
    25. Table created.
    26. Index created.
    27. Table created.
    28. 1 row created.
    29. Type created.
    30. PL/SQL procedure successfully completed.
    31. Type created.
    32. PL/SQL procedure successfully completed.
    33. Table created.
    34. Sequence created.
    35. Table created.
    36. 1 row created.
    37. 1 row created.
    38. 1 row created.
    39. 1 row created.
    40. 1 row created.
    41. 1 row created.
    42. 1 row created.
    43. Commit complete.
    44. Table created.
    45. Table created.
    46. Type created.
    47. Table created.
    48. Table altered.
    49. Table created.
    50. Sequence created.
    51. Sequence created.
    52. Sequence created.
    53. Table created.
    54. Table created.
    55. Sequence created.
    56. Table created.
    57. 1 row created.
    58. 1 row created.
    59. Commit complete.
    60. Table created.
    61. Table created.
    62. Index created.
    63. 1 row created.
    64. Commit complete.
    65. Index created.
    66. Table created.
    67. Table created.
    68. 1 row updated.
    69. Commit complete.
    70. Table altered.
    71. PL/SQL procedure successfully completed.
    72. Table altered.
    73. Table altered.
    74. Table altered.
    75. 1 row updated.
    76. Commit complete.
    77. Index created.
    78. Index created.
    79. Index created.
    80. Index created.
    81. Index created.
    82. Index created.
    83. Index created.
    84. Index created.
    85. Index created.
    86. PL/SQL procedure successfully completed.
    87. Index created.
    88. Index created.
    89. Index created.
    90. 0 rows deleted.
    91. 1 row created.
    92. Commit complete.
    93. Table created.
    94. Index created.
    95. 1 row updated.
    96. Commit complete.
    97. Index dropped.
    98. Index created.
    99. Table created.
    100. Table altered.
    101. Table altered.
    102. Table created.
    103. Sequence created.
    104. Index dropped.
    105. Index created.
    106. Table altered.
    107. 1 row updated.
    108. Commit complete.
    109. SQL> @?/rdbms/admin/owmaggrs.plb;
    110. Type created.
    111. PL/SQL procedure successfully completed.
    112. Function created.
    113. PL/SQL procedure successfully completed.
    114. PL/SQL procedure successfully completed.
    115. Synonym created.
    116. SQL> @?/rdbms/admin/owmaggrb.plb;
    117. Type body created.
    118. SQL> select account_status,wmsys.wm_concat(username) from dba_users group by account_status;
    119. ACCOUNT_STATUS
    120. ----------------------------------------------------------------
    121. WMSYS.WM_CONCAT(USERNAME)
    122. --------------------------------------------------------------------------------
    123. EXPIRED & LOCKED
    124. OUTLN,ORACLE_OCM,DIP,WMSYS,DBSNMP,APPQOSSYS
    125. OPEN
    126. SYS,CAIWUMAO,CAIWUMAO_P,SYSTEM