PLSQL快速入门：分支和循环

--PLSQL编程语言：Oracle数据库对SQL语句扩展。实现更复杂的功能或计算。

--(1)PLSQL基本语法

declare

a number(2);

begin

a := 3;

dbms_output.put_line(a);

end;

declare

a number(2) := 5;

begin

dbms_output.put_line(a);

end;

--(2)if分支语句

declare

a number(2) := 5;

b number(2) := 3;

begin

  if (a > b) then

     dbms_output.put_line(a);

  else

     dbms_output.put_line(b);

  end if;

end;

-- (3)case分支语句

declare

a number(2) := 9;

b number(2) := 5;

begin

  case when a>b then

    dbms_output.put_line(a);

  else

    dbms_output.put_line(b);

  end case;

end;

--(4)while循环

declare

i number(10) := 1;

begin

  while i <= 10 loop

    dbms_output.put_line(i);

    i := i + 1;

  end loop;

end;

--(5)for循环

declare

i number(10);

begin

  for i in 1..10 loop

    dbms_output.put_line(i);

  end loop;

end;

declare

i number(10);

begin

  for i in reverse  1..10 loop

    dbms_output.put_line(i);

  end loop;

end;