Previous Next

PL/SQL program to find max of two numbers

we will write a PL/SQL program to find the largest of two numbers using If…then…Else statement


DECLARE
a NUMBER;
b NUMBER;
BEGIN
a:=&a;
b:=&b;
if(a>b) then
dbms_output.Put_line('max number is '||a);
else
dbms_output.Put_line('max number is '||b);
end if;
END;
/

output

Enter value for a: 10
old   5: a:=&a;
new   5: a:=10;
Enter value for b: 15
old   6: b:=&b;
new   6: b:=15;
max number is 15

Previous Next

C Program C# program PHP program JavaScript Program