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