Dbms condition
Declare
num1 number(2);num2 number(2);
num3 number(2);
begin
num1:=:num1;
num2:=:num2;
num3:=:num3;
if num1>num2 then
if num1>num3 then
dbms_output.put_line('num1 is greater'|| num1);
end if;
Elsif num2>num3 then
dbms_output.put_line('num2 is greater'||num2);
else
dbms_output.put_line('num3 is greater'||num3);
end if;
end;
/
Comments
Post a Comment