Posts

Showing posts from November, 2021

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; /