Re: need help with simple Function

Here's a fun recursive solution....

create or replace function session_hash ( p_sessid in number ) return number
is
begin
return case when nvl(length(p_sessid),1) = 1 then
p_sessid
else
trunc(p_sessid, -1*(length(p_sessid)-1))*power(10,
-1*(length(p_sessid)-1)) +

session_hash( p_sessid - trunc(p_sessid,
-1*(length(p_sessid)-1)) )

        end;
end;
/

yes, i'm a loser. Received on Wed Jan 12 2005 - 13:49:05 CST