3,491
社区成员
发帖
与我相关
我的任务
分享
select unistr(REPLACE(REPLACE('境制出,;制出ABCDEFG;&;制出0910111',';&#x','\'),'&#x','\')) from dual;
SQL>
SQL> with tab as
2 (
3 select '\&\#x5883;\&\#x5236;\&\#x51FA;,;\&\#x5236;\&\#x51FA;ABCDEFG;\&;\&\#x5236;\&\#x51FA;0910111' col from dual
4 )
5 select replace(wm_concat(ac),'\','')
6 from (select decode(regexp_replace(aliscol, '\\&\\#x', ''),
7 aliscol,
8 aliscol,
9 utl_raw.cast_to_nvarchar2(translate(aliscol,'a-zA-Z0-9\&\#x','a-zA-Z0-9'))) ac
10 from (select regexp_substr(col, '[^;]+', 1, rownum) aliscol
11 from tab
12 connect by rownum <= 10) a)
13 ;
REPLACE(WM_CONCAT(AC),'\','')
--------------------------------------------------------------------------------
境,制,出,,,制,出,ABCDEFG,&,制,出
SQL>