How is the if else statement used in Oracle?

2 years ago
William Carter
1 minute

In Oracle, you can use IF-THEN-ELSE statements to implement conditional branching operations. The syntax is as follows:

IF condition THEN
    -- 如果条件为真，执行的代码块
ELSE
    -- 如果条件为假，执行的代码块
END IF;

“condition is a boolean expression, which determines which code block to execute based on its truth value. If condition is true, the THEN code block is executed; if condition is false, the ELSE code block is executed.”

Here is an example:

DECLARE
    x NUMBER := 10;
BEGIN
    IF x > 5 THEN
        DBMS_OUTPUT.PUT_LINE('x大于5');
    ELSE
        DBMS_OUTPUT.PUT_LINE('x小于等于5');
    END IF;
END;

In the above example, if x is greater than 5, output “x is greater than 5”; otherwise, output “x is less than or equal to 5”.

bannerAds