使用以下函数即可完成:
--字符串去重复字符函数
CREATE OR REPLACE FUNCTION remove_rame_string(
v_strings in varchar2
)
return varchar2
IS
v_strings1 varchar2(64) default ' ';
begin
v_strings1:=nvl(replace(rtrim(ltrim(v_strings)),' ',''),' ');
select listagg(c, '') within group(order by id2) into v_strings1
from (select distinct c,id2
from (select row_number() over(partition by e.v_strings1 order by substr(e.v_strings1, iter.pos, 1)) rn,
substr(e.v_strings1, iter.pos, 1) c,1 as id2
from (select v_strings1 from dual) e,
(select rownum pos from user_tables) iter
where iter.pos <= length(e.v_strings1)
order by 1));
return v_strings1 ;
end remove_rame_string;
/
温馨提示:答案为网友推荐,仅供参考