--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 ;