Thanks to all my readers for being so faithful 🙂
I’ll post a new solution to calculate factorial.
This is the one I posted 10 years ago :
https://laurentschneider.com/2005/05/recursive-sql.html
I also used it in the obfuscation contest
with function f (x number) return number
is
begin
return case x when 1 then x else x*f(x-1) end;
end;
select value(t), f(value(t))
from table(sys.odcinumberlist(4,6))t
VALUE(T) F(VALUE(T))
---------- -----------
4 24
6 720
It is neither quicker nor shorter than the one I posted in 2005, but it could not have worked in 2005