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

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 / anil kumar jampana

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

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is difference between left and right outer join?

1038

Why does sql need a server?

1083

Define select, insert, create, delete, update, drop keywords

1094

What do you mean by field in sql?

1125

What are stored procedures in mysql?

1074

What has stored procedures in sql and how we can use it?

1126

What is the difference between inner join and left join?

1038

What does <> sql mean?

1166

How bulk collect improves performance?

1055

Explain the components of sql?

1108

What are the three pl sql block types?

1049

What is data type in sql?

1006

Is pl sql a scripting language?

1082

What is graph sql?

1039

What is rtm stands for?

1173