while_loop.sql

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

create or replace procedure for_loop2(
	v_num1	in	number,
	v_num2	in	number)
is
	i		number(3);
begin

	   i:=v_num1;
	   for i in v_num1..v_num2 loop
	 	dbms_output.put_line(i);
 	   end loop;
 
end;
/