Factorial of a number in PL/SQL
Prerequisite – PL/SQL introduction
In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements.
In declare part, we declare variables and between begin and end part, we perform the operations.
Here, first, we take three variables num, fact, and temp and assign the value in num variable (i.e which number factorial we want).
And then after we assign fact variable to 1.
Examples:
Input : 4
Output : 24
Input : 6
Output : 720
Below is the required implementation:
declare
num number := 6;
fact number := 1;
temp number;
begin
temp :=num;
while( temp >0 )
loop
fact := fact* temp ;
temp := temp -1;
end loop;
dbms_output.put_line( 'factorial of ' || num || ' is ' || fact);
end ;
|
Output :
factorial of 6 is 720.
Last Updated :
10 May, 2018
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...