declare lowerl number:= 1; upperl number:= 3; num varchar2(10); b

declare
lowerl number:= 1;
upperl number:= 3;
num varchar2(10);
begin
for i into lowerl..upperl
loop
num:=num||to_char(lowerl);
if i=3 then upperl:=5;
end loop;
message(num);
What will be the output ?

Question Posted / guest

3 Answers
9150 Views
Oracle, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into l..

Answer / anil kumar jampana

declare
lowerl number:= 1;
upperl number:= 3;
num varchar2(10);
begin
for i in lowerl..upperl
loop
num:=num||to_char(lowerl);
if i=3 then upperl:=5;
end if;
end loop;
message(num);
end;
some changes in the programme.......
it will result 111

Is This Answer Correct ?

13 Yes

0 No

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into l..

Answer / guest

result will be 111

Is This Answer Correct ?

6 Yes

0 No

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into l..

Answer / kotesh

result is 11111

Is This Answer Correct ?

1 Yes

3 No

Post New Answer