Here is an example of a PL/SQL program to calculate the factorial of a given number:
PL/SQL Program to Calculate Factorial Example
DECLARE
num INTEGER := 5;
factorial INTEGER := 1;
BEGIN
-- Calculate the factorial of the given number
FOR i IN 1..num LOOP
factorial := factorial * i;
END LOOP;
-- Print the result
DBMS_OUTPUT.PUT_LINE('The factorial of ' || num || ' is ' || factorial);
END;
This code calculates the factorial of the number 5, which is 120. The result is then printed to the console using the DBMS_OUTPUT.PUT_LINE
function. The output of the program would be:
The factorial of 5 is 120
In this example, the num
variable is initialized to 5, and the factorial
variable is initialized to 1. The code then uses a FOR
loop to iterate over the numbers from 1 to num
, and calculates the factorial by multiplying each number by the current value of factorial
. This continues until the loop has finished, at which point factorial
contains the final result. Finally, the result is printed to the console using the DBMS_OUTPUT.PUT_LINE
function.
You can modify the PL/SQL code to calculate the factorial of any number by changing the value of the num
variable. You can also use the DBMS_OUTPUT.PUT_LINE
function to print intermediate results, or to print the result in a different format.