result is 11111

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 / kotesh

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

Answer Posted / kotesh

result is 11111

Is This Answer Correct ?

1 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How many postgresql users are there, worldwide?

1128

how to load data files into tables with 'mysqlimport'? : Sql dba

1146

Which table is left in join?

1017

what is the difference between nested subquery and correlated subquery?

1093

Can we use pl sql in sql server?

1136

What are the 3 modes of parameter?

1206

What is query execution plan in sql?

1249

Can we use distinct and group by together?

1104

Explain what is a field in a database and record in a database?

1180

What is primary key secondary key alternate key candidate key?

1087

What are the two characteristics of a primary key?

1031

Can a view be mutating? If yes, then how?

1087

How do you remove duplicate records from a table?

981

is it possible to pass an object or table to a procedure as an argument?

1178

what is a table in a database ? : Sql dba

1090