Oracle函数中被零除的处理

DECLARE
    numerator NUMBER := 10;
    denominator NUMBER := 0;
    result NUMBER;
BEGIN
    BEGIN
        result := numerator / denominator;
    EXCEPTION
        WHEN ZERO_DIVIDE THEN
            DBMS_OUTPUT.PUT_LINE('Error: Division by zero is not allowed.');
            result := NULL; -- 或者设置一个默认值
    END;
END;
/

DECLARE
    numerator NUMBER := 10;
    denominator NUMBER := 0;
    result NUMBER;
BEGIN
    IF denominator <> 0 THEN
        result := numerator / denominator;
    ELSE
        DBMS_OUTPUT.PUT_LINE('Error: Division by zero is not allowed.');
        result := NULL; -- 或者设置一个默认值
    END IF;
END;
/