Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 ?

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



More SQL PLSQL Interview Questions

how to run 'mysql' commands from a batch file? : Sql dba

0 Answers  


What is the use of %rowtype?

0 Answers  


How can you view the errors encountered in a trigger?

0 Answers  


What is indexing in sql and its types?

0 Answers  


how many groups of data types? : Sql dba

0 Answers  






what is meant by tuning and tk proof?

2 Answers  


What is the primary use of normalization?

0 Answers  


What are all different types of collation sensitivity?

0 Answers  


What are the constraints available in sql?

0 Answers  


What is schema in sql example?

0 Answers  


Does group by remove duplicates?

0 Answers  


Which is the best place to learn hadoop?

1 Answers  






Categories