(1) Write a program to print factorial of a given no.using pl/sql.

SQL> declare

2 i number;

3 a number;

4 f number:=1;

5 Begin

6 a:=&a;

7 for i in 1..a

8 loop

9 f:=f*i;

10 end loop;

11 dbms_output.put_line('The factorial is:'||f);

12 end;

13 /

Output :

Enter value for a: 4

old 6: a:=&a;

new 6: a:=4;

PL/SQL procedure successfully completed.