oracle基础-pl/sql中if语句

条件语句(if else)

declare 
  --定义变量保存输入的数字
  pnum number := #
begin
  if pnum = 0 then 
    dbms_output.put_line('0');
  elsif pnum = 1 then
    dbms_output.put_line('1');
  else 
    dbms_output.put_line('2');
  end if;
end;

循环语句(while loop)

declare
  pnum number := -1;
begin
  while pnum <= 10 loop
    dbms_output.put_line(pnum);
    pnum := pnum + 1;
  end loop;
end;

declare
  pnum number := 1;
begin
  loop
    exit when pnum >= 10;
    dbms_output.put_line(pnum);
    pnum := pnum + 1; 
  end loop;
end;

declare
  pnum number := 1;
begin
  --必须是连续的区间
  for pnum in 1 .. 10 loop
    dbms_output.put_line(pnum);
    end loop;
  end;