Oracle中的几种控制语句if..else,for,loop,while

--if ...else
 DECLARE
cou NUMBER ;
BEGIN
cou := 10 ;
IF cou>10 THEN
DBMS_OUTPUT.put_line('cou = '||cou) ;
ELSIF cou<5 THEN
DBMS_OUTPUT.put_line('值小于 5') ;
ELSE
DBMS_OUTPUT.put_line('条件不满足 ') ;
END IF ;
END ;

--if...elsif...else
DECLARE
    v_empno emp.empno%TYPE := 7369;
    V_salary emp.sal%TYPE;
    V_comment VARCHAR2(35);
 BEGIN
   SELECT sal INTO v_salary FROM emp WHERE empno=v_empno;
   IF v_salary<1500 THEN
       V_comment:= 'Fairly less';
   ELSIF v_salary <3000 THEN
      V_comment:= 'A little more';
   ELSE
      V_comment:= 'Lots of salary';
   END IF;
   DBMS_OUTPUT.PUT_LINE(V_comment);
 END;
 

--loop循环
DECLARE
   cou number;
BEGIN
  cou:=1;
  loop
    dbms_output.put_line('cou = '||cou);
    cou := cou+1;
    exit when cou >10;
    end loop;  
END;

--while 循环
declare 
cou number ;
begin
  cou:=1;
  while (cou<=10)loop
    dbms_output.put_line('cou='||cou);
    cou:=cou+1;
  end loop;
end;


--for 循环
DECLARE
cou NUMBER ; 
BEGIN
FOR cou IN 1..100 LOOP
DBMS_OUTPUT.put_line('cou = '||cou) ;
END LOOP ;
END ;