result will be 111

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
8776 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / guest

result will be 111

Is This Answer Correct ?

6 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is delimiter sql?

924

How to avoid duplicate records in a query?

954

What does pl sql stand for?

1065

How do you optimize a stored procedure in sql?

898

What are the advantages of sql? Explain

1054

How exception is different from error?

971

Does sql use python?

979

What are the benefits of pl/sql packages?

1036

What is replication id?

886

What is relationship? How many types of relationship are there?

1075

how does a local variable is defined using t-sql? : Transact sql

954

How do I view a table in sql?

956

How to create an array in pl/sql?

1015

what are the properties and different types of sub-queries? : Sql dba

971

how to increment dates by 1 in mysql? : Sql dba

929