Answer to Question #257611 in Databases | SQL | Oracle | MS Access for Tarurendra Kushwah

Question

Write a procedure to calculate factorial of a number entered by user.

Answer 1

Declare  
num   number:= #  
fact number:= 1;  
temp number;  
begin  
  temp := num;  
   while (num > 0)
loop
    fact := fact * num;  
    num   := num - 1;  
end loop;
  Dbms_Output.Put_line('factorial of ' || temp ||  '  is ' || fact);