PL SQL简单

--while loop 循环
declare
 ii int;
begin
 ii:=10;
 while(ii<20) loop
   ii:=ii+1;
   dbms_output.put_line(ii);
 end loop;
end;

--普通loop 循环
declare
 ii number(4);
begin
  ii:=1;
  loop  
   dbms_output.put_line(ii);
   exit when ii>5; --  推出循环
   ii:=ii+1; 
  end loop;
end;


-- for loop 循环
declare
begin
 for ii in 1..10 loop
  dbms_output.put_line(ii);
 end loop;
end;


-- if判断
declare
 cut number(2);
 eno number(6);
begin
 eno := &empno;
 select count(*) into cut from emp where empno=eno; --按条件查询，是否成功
 if cut=1 then --判断
  dbms_output.put_line('成功');
 else
  dbms_output.put_line('失败');
 end if;
end;