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

What is the advantage of index in sql?

976

Why is the cursor important?

1048

What is the basic structure of an sql?

1113

What do you mean by table in sql?

999

What is dbo in sql?

977

Differentiate between pl/sql and sql?

1158

how to show all tables with 'mysql'? : Sql dba

1127

how many triggers are allowed in mysql table? : Sql dba

1078

what is the difference between undefined value and null value? : Sql dba

1110

What is lookup table in sql?

1055

Are left and right joins the same?

1094

Explain what is rdbms?

1047

What is program debugging?

1259

What is sql key?

999

what are the types of join and explain each? : Sql dba

1047