SQLize Online / PHPize Online  /  SQLtest Online

-- WITH RECURSIVE seq AS(SELECT 0 AS v UNION ALL SELECT v + 1 FROM seq WHERE v < 10) -- SELECT v AS n FROM seq; CREATE OR REPLACE PROCEDURE factorial_number( n NUMBER) AS factorial NUMBER := 1; -- Initialize BEGIN FOR i IN 1..n LOOP -- Loop normally dbms_output.put_line( 'Beginning iteration ' || i || ' of loop. ' || 'Factorial = ' || factorial || ' multiplying by ' || i ); factorial := factorial * i; -- Multiply by i not i-1 END LOOP; DBMS_OUTPUT.PUT_LINE (factorial); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE ('Error!'); END; WITH RECURSIVE seq AS(SELECT 0 AS v UNION ALL SELECT v + 1 FROM seq WHERE v < 10) SELECT v AS n, factorial(v) AS factorial FROM seq;