PL/SQL Procedure to Find Large from Three Numbers

PL/SQL Procedure to Find Large from Three Numbers:



create or replace procedure larg_no(n1 number,n2 number,n3 number) is
begin
if(n1>n2 and n1>n3) then
dbms_output.put_line(n1||' is the largest number');
elsif(n2>n3) then
dbms_output.put_line(n2||' is the largest number');
else
dbms_output.put_line(n3||' is the largest number');
end if;
end;

Leave a Reply

Your email address will not be published. Required fields are marked *

three × five =