For Loop:
Set serveroutput on;
declare
v_no number(4):=&b;
f number(4):=1;
begin
for i in 1..v_no
loop
f:=f*i;
end loop;
Dbms_output.put_line(‘the factorial of ‘||v_no||’ is:’||f);
end;
/
Output on top.
Related Articles
-
To Print the Prime numbers within the given range of numbers.
Set serveroutput on; declare counter NUMBER; n number := &n; begin counter := 0; for i in 2..n LOOP...
-
CURSOR in PL/SQL – Sybscit Semester 3
A cursor is a pointer to an area in the memory. It is specific temporary work area for a...
-
Introduction to SQL
What is SQL ? SQL is Structured Query Language, It is an interface between user and relational database. For...
-
Program to print Factorial in PL/SQL using While Loop
While Loop : Set Serveroutput On; DECLARE v_no NUMBER := &no; f NUMBER := 1; n_temp NUMBER; BEGIN n_temp...
-
Difference between Function and Procedure in PL/SQL
Difference Functions Procedure 1 A function always returns a value. 1 A procedure may or may not return a...
-
Program to print triangle pattern
set serveroutput on; declare a number:=&a; begin for i in 1..a loop for j in 1..i loop dbms_output.put(‘*’); end...
-
Program to print Factorial using Basic Loop
Basic Loop Set serverouput on; DECLARE v_no NUMBER := &no; f NUMBER := 1; n_temp NUMBER; BEGIN n_temp:= v_no;...
