一、IF
DECLARE
A NUMBER := 4;
BEGIN
IF A > 0 AND A < 3 THEN
DBMS_OUTPUT.PUT_LINE('小');
ELSIF A >= 3 AND A < 6 THEN
DBMS_OUTPUT.PUT_LINE('大');
ELSE
DBMS_OUTPUT.PUT_LINE('错误');
END IF;
END;
/
二、CASE
简单型的case
DECLARE
A NUMBER := 4;
BEGIN
CASE TRUE
WHEN A > 0 AND A < 3 THEN
DBMS_OUTPUT.PUT_LINE('小');
WHEN A >= 3 AND A < 6 THEN
DBMS_OUTPUT.PUT_LINE('大');
ELSE
DBMS_OUTPUT.PUT_LINE('错误');
END CASE;
END;
/
搜索型的case
DECLARE
A NUMBER := 4;
BEGIN
CASE
WHEN A > 0 AND A < 3 THEN
DBMS_OUTPUT.PUT_LINE('小');
WHEN A >= 3 AND A < 6 THEN
DBMS_OUTPUT.PUT_LINE('大');
ELSE
DBMS_OUTPUT.PUT_LINE('错误');
END CASE;
END;
/
