Find the factorial of a number in PLSQL
This can be defined as the specified number and it multiplies with the previous numbers till the end without multiplies with zero. Using the PLSQL we can write an easy program to find the factorial of a number in PLSQL. Let us see how we can write a program for that.
In the above image, I have captured examples of up to 10 numbers. Using this way you can calculate it for any given number.
Here let us see how to write a PLSQL program for this.
Given a number, your task to print the factorial of that number using PLSQL.
Consider that the given number is four. The factorial of this number would be 24.
Input : 4 Output : 24
4! = 4 * 3 * 2 * 1 = 24
Input : 3 Output : 6
Basic structure of PLSQL block
declare -- We have to declare all the variables here begin -- for start block -- make a program here end -- for end block The program of factorial of a number in PLSQL is given below: declare -- it gives the final answer after computation fac number :=1; -- given number n -- taking input from user n number := &1; -- start block begin -- start while loop while n > 0 loop -- multiple with n and decrease n's value fac:=n*fac; n:=n-1; end loop; -- end loop -- print result of fac dbms_output.put_line(fac); -- end the begin block end;
Output (If given input as 3)
Factorial, in mathematics, the value of all positive integers less than or equal to a given positive integer and denoted by that integer and an exclamation point. Thus, factorial six is written as 6! meaning 6*5*4*3*2*1 is equal to 760. Factorial zero is defined as equal to 1.