Sunday, November 15, 2009

PL/SQL Program

Write a program to display 10 reverse number using for loop

SQL> declare
i number;
begin
for i in reverse 1..10
loop
dbms_output.put_line(i);
end loop;
end;
.
SQL> /
10
9
8
7
6
5
4
3
2
1

PL/SQL procedure successfully completed.


Write a program to display 1 to 10 number using for loop

SQL>declare
i number;
begin
for i in 1..10
loop
dbms_output.put_line(i);
end loop;
end;

SQL> /
1
2
3
4
5
6
7
8
9
10

No comments:

Post a Comment