Tuesday, June 19, 2018

Create a procedure of calculator - DBMS (Procedure)


create or replace procedure cal(no1 in number,no2 in number,symbol in varchar2)
is ans  number;
begin
if symbol='+'
then
ans:=no1+no2;
elsif symbol='-'
then
ans:=no1-no2;
elsif symbol='*'
then
ans:=no1*no2;
elsif symbol='/'
then
ans:=no1/no2;          
end if;
dbms_output.put_line('The Answer is :'||ans);
end;

No comments:

Post a Comment