PL/SQL Program To Add Two Numbers

In the previous tutorial we have learnt much about PL/SQL variables, operators, data types and other such fundamental topics. Let us get into real programming now onwards.

For starters, let us look at a PL/SQL program to add two numbers or integers and fetching the result into a third variable.

This program takes two inputs one for each variable and adds the result to a third variable and prints it. 

PL/SQL Program To Add Two Numbers

Declare
Var1 integer;
Var2 integer;
Var3 integer;
Begin
Var1:=&var1;
Var2:=&var2;
Var3:=var1+var2;
Dbms_output.put_line(var3);
End;
/

Output

Since, we need variables in this program code so we need to declare them in the declaration section. In the begin section, we need to initialize and take input from the user. All the logical and mathematical calculations for this program logic need to be established here.

Var1:=&var1;
This statement assigns the value that the user enters for the variable. Similarly, we have taken input for next variable.

Var3:=var1+var2
This statement is used to assign the calculated values of Var1 and Var2 into the third variable.

Dbms_output.put_line()
The statement takes a parameter which can be printed onto the console screen.

Note: For this statement to work properly, it is sometimes necessary to use a particular statement as mentioned below:

When you start the SQL Command Prompt/Terminal, just type:


Set serveroutput on;

This statement is used to activate the working of print statement on the console screen. This will help to get the proper output onto the screen/terminal as expected.

Finally, the End statement is used to terminate the code.