Wap to find Find Factorial for loop
declare
i number(2);begin
for i in 1..10 loop
dbms_output.put(i);
end loop;
dbms_output.new_line;
end;
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