Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE OR REPLACE FUNCTION fact(pinX IN INT)
  RETURN INT
IS
  nResult INT := 1;
BEGIN
  FOR i IN 2..pinX LOOP
    nResult := i * nResult;
  END LOOP;
  
  RETURN nResult;
END FACT;
/
SELECT * FROM USER_ERRORS WHERE NAME = 'FACT' and type = 'FUNCTION'
SELECT FACT(0) AS FACT_0,
       FACT(1) AS FACT_1,
       FACT(2) AS FACT_2,
       FACT(3) AS FACT_3,
       FACT(4) AS FACT_4,
       FACT(5) AS FACT_5,
       FACT(6) AS FACT_6,
       FACT(7) AS FACT_7,
       FACT(8) AS FACT_8,
       FACT(9) AS FACT_9,
       FACT(10) AS FACT_10
  FROM DUAL


FACT_0
FACT_1
FACT_2
FACT_3
FACT_4
FACT_5
FACT_6
FACT_7
FACT_8
FACT_9
FACT_10


1
1
2
6
24
120
720
5040
40320
362880
3628800