for_loop1.sql

学习PL/SQL时收集的一些经典的SQL源代码

create or replace procedure for_loop1(
	v_num1	in	number,
	v_num2	in	number)
is
	i		number(3);
begin
	if v_num1<=v_num2 then
	   i:=v_num1;
	   for i in v_num1..v_num2 loop
	 	dbms_output.put_line(i);
 	   end loop;
 	else
 	   i:=v_num2;	   		 	
	   for i in v_num2..v_num1 loop
	 	dbms_output.put_line(i);
 	   end loop;
	end if;
end;
/