Recursive PL/SQL
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 :
ref: using recursion with PL/SQL
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;
/
ref: using recursion with PL/SQL
Posted by Laurent Schneider at 1/30/2006 03:23:00 PM
Permalink : Recursive PL/SQL
Post to :
del.icio.us -
furl -
digg -
reddit -
co.mments
3 Comments:
SQL> select f('DHSGHDADSFDF') from dual
2 /
F('DHSGHDADSFDF')
----------------------------------------
DHSGHDADSFDF
SQL>
?
Probably is meant
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(v, Substr(v, 1, 1), ''));
END IF;
END;
/
Regards
Maxim
sorry friends, I apologize for this copy paste error... I just posted my first try, but now I corrected my post!
Post a Comment
<< Home