Greatest number

[aafubaafu]

I have need program in PL/SQL that take 3 inputs and tell us greatest number.

[amaanlovefiza]

CREATE OR REPLACE PROCEDURE max_3(n_1 IN NUMBER,n_2 IN NUMBER,n_3 IN NUMBER,result OUT NUMBER)
AS
BEGIN
IF (n_1 >n_2) AND (n_1>n_3) THEN
result:=n_1;
ElSIF n_2>n_3 THEN
result:=n_2;
ELSE
result:=n_3;
END IF;
END;

DECLARE
RESULT NUMBER;
BEGIN
MAX_3(23,45,34,RESULT);
DBMS_OUTPUT.PUT_LINE(RESULT);
END;