Skip to main content

Pl/SQl Program for finding minimum of two number using Procedure


declare
  a number;
  b number;
  c number;
  procedure find_min(x in number, y in number, z out number) IS
  begin
    if (x < y) then
      z := x;
    else
      z := y;
    end if;
  end;
begin
  a := 23;
  b := 34;
  find_min(a, b, c);
  dbms_output.put_line('The minimum of (23,32): ' || c);
end;

Comments

Popular posts from this blog

Pl/SQL program to find square of a user input number Using Function

declare   value1 number;   value2 number;   mytotal number;   function myfun(myval1 in number, myval2 in number) return number is     total number;   begin     total := myval1 ** myval2;     dbms_output.put_line(total);     return total;   end; begin   value1 :=&val1;   value2 := &val2;  mytotal:= myfun(value1, value2); end;