12c删除不干净 oracle_oracle 12c删除了wm_concat函数，升级用户小心

SQL> with t as(select 1 id, 'a' name from dual union all

2  select 1 id, 'b' name from dual union all

3  select 2 id, 'c' name from dual union all

4  select 2 id, 'd' name from dual union all

5  select 2 id, 'e' name from dual )

6  select id,wmsys.wm_concat(name) name from t group by id;

1 a,b

2 c,e,d

SQL> with t as(select 1 id, 'a' name from dual union all

2  select 1 id, 'b' name from dual union all

3  select 2 id, 'c' name from dual union all

4  select 2 id, 'd' name from dual union all

5  select 2 id, 'e' name from dual )

6  select id,wm_concat(name) name from t group by id;

1 a,b

2 c,e,d

SQL> show rel

release 1102000200

~~~~~~~~~~~~~~~~~

SQL> with t as(select 1 id, 'a' name from dual union all

2  select 1 id, 'b' name from dual union all

3  select 2 id, 'c' name from dual union all

4  select 2 id, 'd' name from dual union all

5  select 2 id, 'e' name from dual )

6  select id,wmsys.wm_concat(name) name from t group by id;

select id,wmsys.wm_concat(name) name from t group by id

*

第 6 行出现错误:

ORA-00904: "WMSYS"."WM_CONCAT": 标识符无效

SQL> with t as(select 1 id, 'a' name from dual union all

2  select 1 id, 'b' name from dual union all

3  select 2 id, 'c' name from dual union all

4  select 2 id, 'd' name from dual union all

5  select 2 id, 'e' name from dual )

6  select id,wm_concat(name) name from t group by id;

select id,wm_concat(name) name from t group by id

*

第 6 行出现错误:

ORA-00904: "WM_CONCAT": 标识符无效

SQL> show rel

release 1201000100