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;
/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
