Practical Practice 2
Oracle Practice
Write a program to enter two numbers and find their sum in PLSQL block .
Write a program to enter two numbers and find their sum in PLSQL block .
SOLUTION
--Static code
set serveroutput on;
DECLARE
number1 number := 10;
number2 number := 20;
tot number;
BEGIN
tot := number1 + number2;
dbms_output.put_line('The sum of 2 number is :-'||tot);
END;
/
--Dynamic code
set serveroutput on;
DECLARE
number1 number := &number1;
number2 number := &number2;
tot number;
BEGIN
tot := number1 + number2;
dbms_output.put_line('The sum of 2 number is :-'||tot);
END;
/
--Dynamic code set serveroutput on; DECLARE number1 number := &number1; number2 number := &number2; tot number; BEGIN tot := number1 + number2; dbms_output.put_line('The sum of 2 number is :-'||tot); END; /