Summary: in this tutorial, you will learn how to develop a PL/SQL function and how to call it in various places such as an assignment statement, a Boolean expression, and an SQL statement. Creating a PL/SQL function. Similar to a procedure, a PL/SQL function is a reusable program unit stored as a schema object in the Oracle Database. Calculate Factorial of a number Suppose 4!=4.3.2.1.

Factorial Program In Pl Sql Syntax

Here you will get pl/sql program to find factorial of a number.

We can calculate factorial of a number by multiplying it with all the numbers below it.

For example factorial of 5 = 5 x 4 x 3 x 2 x 1 = 120.

PL/SQL Program to Find Factorial of a Number

Transact-SQL also gives you this option to repeat the expression using CTE (Common Table Expression). A factorial is denoted by n! The factorial of a number is defined as n! Our Expert team is ready to answer all your questions immediately-Feel free to speak in Tamil/English. (Example:Events info/Lecture Notes/Off-Campus & All Jobs/Projects & All education information).

Output

Factorial Program In Pl Sql Query

Enter value for n: 10
old 7: n:=&n;
new 7: n:=10;
factorial=3628800

Factorial Program In Pl Sql W3schools