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

Popular posts from this blog

Download Satyameva Jayate 2 movie free