Write a PL/SQL program to print the sequence 103, 99, 96...3.

Question

Accepted Answer

PL/SQL program to print numbers in descending order from 103 to 3

Use a loop to iterate from 103 to 3
Print each number in the loop
Decrement the loop counter by 3 in each iteration

Accepted Answer

DECLARE

P_INPUT01 NUMBER := &NUMBER01 ;
P_INPUT02 NUMBER := &NUMBER02 ;

v_store number ;

begin

for i in reverse P_INPUT02..P_INPUT01 loop 
v_store := mod( i , 3 ) ;

if v_store = 0 then 
dbms_output.put_line (i) ;
end if ;

end loop ;

end ;

Accepted Answer

declare
v_num number :=103
begin
while v_num >=3 loop
dbms_output.put_line(v_num);
v_num := v_num-4;
end loop;
end;

Accepted Answer

ls=[103]

for i in range(4,103,3):

ls.append(str(ls[0]-i))

print(ls)

above is in python

Accepted Answer

set serveroutput on;

declare

i number :=103;

i_target number :=100;

begin

DBMS_OUTPUT.put_line(i);

while(i>3) loop

if(i>i_target) then

i:=i-4;

else

i:=i-3;

end if;

DBMS_OUTPUT.put_line(i);

end loop;

end;

Accepted Answer

Begin

For i reverse 1..103

Loop

If mod(i,3)=0 then

Dbms_output.put_line( i);

End if;

End loop;

End;

Accepted Answer

set serveroutput on ;

declare

x number;

begin

for i in reverse 1..102 loop

if mod(i,3)=0 then

dbms_output.put_line(i);

end if;

end loop;

end;

Accepted Answer

Declare

i number;

Begin

for i in reverse 1..103

loop

dbms_output.put_line(i);

end loop;

end;

Accepted Answer

Declare

i number;

Begin

for i in reverse 1..103

loop

if mod(i,3)=0 then

dbms_output.put_line(i);

end if;

end loop;

end;

Write a PL/SQL program to print the sequence 103, 99, 96...3.

TCS Plsql Developer interview questions & answers

Popular interview questions of Plsql Developer