create or replace function addmy_num(x in number, y in number) return number is
z number;
begin
z := x + y;
return z;
end;
create or replace function subtractmy_num(x in number, y in number) return number is
z number;
begin
z := x - y;
return z;
end;
create or replace function multiplymy_num(x in number, y in number) return number is
z number;
begin
z := x * y;
return z;
end;
create or replace function dividemy_num(x in number, y in number) return number is
z number;
begin
z := x / y;
return z;
end;
declare
a number;
b number;
c number;
choice varchar2(10);
begin
dbms_output.put_line('Enter the first number');
a:=&enternum1;
dbms_output.put_line('Enter the second number');
b:=&enternum2;
dbms_output.put_line('Enter your operation choice');
choice:='&symbol';
/*if choice='+' then
c:=addmy_num(a,b);
else if choice='-' then
c:=subtract(a,b);
else if choice='*' then
c:=multiply(a,b);
else if choice='/' then
c:=divide(a,b);*/
case choice
when '+' then
c:=addmy_num(a,b);
dbms_output.put_line('the addition of two number '|| c);
when '-' then
c:=subtractmy_num(a,b);
dbms_output.put_line('the subtraction of two number '|| c);
when '*' then
c:=multiplymy_num(a,b);
dbms_output.put_line('the multiply of two number '|| c);
when '/' then
c:=dividemy_num(a,b);
dbms_output.put_line('the divide of two number '|| c);
else
dbms_output.put_line('No option selected');
end case;
end;
Comments
Post a Comment