Find the factorial of a number in pl/sql

Find the factorial of a number in pl/sql

Last Updated : 06 May, 2018

Given a number, your task to print the factorial of that number using pl/sql. Examples:

Input : 5
Output : 120

Explanation: 5! = 5 * 4 * 3 * 2 * 1 = 120

Input : 4
Output : 24

Basic structure of pl/sql block

declare
-- declare all the variables

begin  -- for start block
-- make a program here

end -- for end block

The program of factorial of a number in pl/sql is given below:

SQL

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 5)

Find the factorial of a number in pl/sql

devanshuagarwal

Improve

Article Tags :

Practice Tags :

Misc

Similar Reads

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 tem

PHP | Factorial of a number

In mathematics, the factorial of a number is the product of all positive integers less than or equal to that number. It is denoted by n!. The factorial of a number can be expressed mathematically as: n! = n * (n-1) * (n-2) * ........ * 1Methods to Calculate Factorials in PHPThere are several methods

One line function for factorial of a number

Factorial of a non-negative integer, is multiplication of all integers smaller than or equal to n. Example : Factorial of 6 is 6 * 5 * 4 * 3 * 2 * 1 which is 720. We can find the factorial of a number in one line with the help of Ternary operator or commonly known as Conditional operator in recursio

First digit in factorial of a number

Given a positive integer n, find the first digit in its factorial. Examples : Input : n = 5 Output : 1 Factorial of 5 is 120 and first digit is 1. Input : 1000 Output : 4 A simple solution is to compute factorial of number, then find first digit in it. The above solution causes overflow soon. A bett

GCD of two numbers 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. Given two numbers and task is to find the GCD (Greatest

Sum of digits equal to a given 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. Given a number and range and the task is to display all

Find maximum power of a number that divides a factorial

Given two numbers, fact and n, find the largest power of n that divides fact! (Factorial of fact). Examples:Â Input : fact = 5, n = 2 Output : 3 Explanation: Value of 5! is 120. The largest power of 2 that divides 120 is 8 (or 23 Input : fact = 146, n = 15 Output : 35 The idea is based on Legendreâ€™s

Find the unit place digit of sum of N factorials

Given a number N, the task is to find units place digit of the first N natural numbers factorials, i.e. 1!+2!+3!+....N! where N<=10e18.Examples: Input: n = 2 Output: 31! + 2! = 3Last digit is 3Input: n = 3Output: 91! + 2! + 3! = 9Last digit is 9 Brute Force Approach: In this approach, we are calc

Sum of the first and last digit 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. Given a number n, the task is to find the sum of its fi

Find all factorial numbers less than or equal to n

A number N is called a factorial number if it is the factorial of a positive integer. For example, the first few factorial numbers are1, 2, 6, 24, 120, ...Given a number n, print all factorial numbers smaller than or equal to n. Examples : Input: n = 100Output: 1 2 6 24Input: n = 1500Output: 1 2 6 2