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
8933 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 do I run sql?

1183

How to disable a trigger name update_salary?

1266

Where do we use pl sql?

993

Does asenumerable execute the query?

1043

what is a tablespace? : Sql dba

1051

what are the t string functions available in tsql? : Transact sql

1007

What do you mean by dbms? What are its different types?

1018

what is error ora-03113: end-of-file on communication channel?

1165

What is the max nvarchar size?

982

How do you take the union of two tables in sql?

985

Is sql easier than java?

1016

What are sql indexes?

999

What are the basic sql commands?

1092

What is exit statement?

1015

What is pls_integer in pl sql?

1105