it will be a good week !
I found an elegant way to solve a query with recursive pl/sql.
an user wanted to have DHSGHDADSFDF translated in DHSGAF, that is, duplicated chars removed, order retained.
here is my function :
create or replace function f(v varchar2) return varchar2 is begin if (v is null) then return null; else return substr(v,1,1)||f(replace(substr(v,2),substr(v,1,1)); end if; end; /