sql存储过程算法

 1 CREATE proc [dbo].[EXEC003] as
 2 declare @num int;
 3 begin
 4 set @num = 10;
 5 while (@num > 0 )
 6 BEGIN
 7    IF(@num %2 = 0 )
 8       BEGIN
 9       PRINT(@NUM);
10       END
11    SET @num -= 1;
12 END
13 end

 1 create or replace procedure EXEC003 as 
 2  List int := 10;
 3  begin
 4 
 5  while( List > 0 ) loop
 6     if mod(List,2)  = 0 then
 7            Dbms_Output.put_line(List);
 8           end if;
 9     List := List - 1;
10  end loop;
11  end;
12 
13 
14 --测试
15 begin
16 
17 exec003 ;
18 commit;
19 end;