Sum Of Two Numbers in PL/SQL

To compute the sum of two numbers in PL/SQL, you can create a simple block where you declare two number variables, a result variable, and then add the two numbers together. Here's a basic example:

DECLARE
    num1 NUMBER := 5;  -- Example number
    num2 NUMBER := 10; -- Example number
    result NUMBER;
BEGIN
    result := num1 + num2;

    DBMS_OUTPUT.PUT_LINE('The sum of ' || num1 || ' and ' || num2 || ' is: ' || result);
END;
/

In this example, 5 and 10 are added together to give a result of 15, which is then displayed. You can replace the example numbers with your desired values.

Adding Two Numbers in PL/SQL:

DECLARE
    num1 NUMBER := 10;
    num2 NUMBER := 20;
    sum NUMBER;
BEGIN
    sum := num1 + num2;
    DBMS_OUTPUT.PUT_LINE('Sum: ' || sum);
END;
/

PL/SQL Program for Addition of Two Numbers:

DECLARE
    num1 NUMBER := 30;
    num2 NUMBER := 40;
    sum NUMBER;
BEGIN
    sum := num1 + num2;
    DBMS_OUTPUT.PUT_LINE('Sum: ' || sum);
END;
/

PL/SQL Addition Operator Example:

DECLARE
    num1 NUMBER := 15;
    num2 NUMBER := 25;
    sum NUMBER;
BEGIN
    sum := num1 + num2;
    DBMS_OUTPUT.PUT_LINE('Sum: ' || sum);
END;
/

Sum of Variables in PL/SQL:

DECLARE
    a NUMBER := 50;
    b NUMBER := 60;
    result NUMBER;
BEGIN
    result := a + b;
    DBMS_OUTPUT.PUT_LINE('Sum: ' || result);
END;
/

Adding Input Numbers in PL/SQL:

DECLARE
    num1 NUMBER;
    num2 NUMBER;
    sum NUMBER;
BEGIN
    -- Prompt for user input
    num1 := &input1;
    num2 := &input2;

    sum := num1 + num2;
    DBMS_OUTPUT.PUT_LINE('Sum: ' || sum);
END;
/

PL/SQL Sum Function:

DECLARE
    num1 NUMBER := 70;
    num2 NUMBER := 80;
    sum NUMBER;
BEGIN
    sum := NVL(num1, 0) + NVL(num2, 0);
    DBMS_OUTPUT.PUT_LINE('Sum: ' || sum);
END;
/