(一)条件控制:
(1)if语句控制语法
if v_var='a' then
begin
--statement
end
elsif v_var='b' then
begin
--statement
end
else
begin
end
end if;
(2)case语句
BEGIN
CASE ‘&grade’
WHEN ‘A’ THEN DBMS_OUTPUT.PUT_LINE(‘优异’);
WHEN ‘B’ THEN DBMS_OUTPUT.PUT_LINE (‘优秀’);
WHEN ‘C’ THEN DBMS_OUTPUT.PUT_LINE (‘良好’);
WHEN ‘D’ THEN DBMS_OUTPUT.PUT_LINE (‘一般’);
WHEN ‘F’ THEN DBMS_OUTPUT.PUT_LINE (‘较差’);
ELSE DBMS_OUTPUT.PUT_LINE (‘没有此成绩’);
END CASE;
END;
CASE ‘&grade’
WHEN ‘A’ THEN DBMS_OUTPUT.PUT_LINE(‘优异’);
WHEN ‘B’ THEN DBMS_OUTPUT.PUT_LINE (‘优秀’);
WHEN ‘C’ THEN DBMS_OUTPUT.PUT_LINE (‘良好’);
WHEN ‘D’ THEN DBMS_OUTPUT.PUT_LINE (‘一般’);
WHEN ‘F’ THEN DBMS_OUTPUT.PUT_LINE (‘较差’);
ELSE DBMS_OUTPUT.PUT_LINE (‘没有此成绩’);
END CASE;
END;
(二)循环控制
(1)basic loop
loop
--statement
exit when exp
end loop;
(2)PL/SQL FOR循环例子
for i in 1..maxvalue loop
--statement
end loop;
(3)while loop
while exp loop
--statement
end loop;