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
9049 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

how to write date and time literals? : Sql dba

1010

Is pl sql and postgresql same?

1182

What are few of the schema objects that are created using PL/SQL?

1081

What are the datatypes available in pl/sql ?

1151

What is on delete set null?

1135

how to fetch common records from two tables? : Sql dba

1251

What are sql indexes?

1046

What are the uses of merge?

1225

Can a varchar be a primary key?

1049

Which is better join or inner query?

1127

Write a query to find the names of users that begin with "um" in sql?

1045

What trigger means?

1036

what is 'mysqlcheck'? : Sql dba

1063

Is sqlexception checked or unchecked?

1010

Can a table have no primary key?

1110