Skip to main content

Pl/SQL Program to find Square Of a Number



declare
a number;
procedure squarenum(x IN OUT number)
Is
begin
  x:= x*x;
  end;
begin
  a:=29;
  squarenum(a);
  dbms_output.put_line(' Square of (23): ' || a);
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;