declare lowerl number:= 1; upperl number:= 3; num varchar2(10);

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 / anil kumar jampana

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

Answer Posted / anil kumar jampana

declare
lowerl number:= 1;
upperl number:= 3;
num varchar2(10);
begin
for i in lowerl..upperl
loop
num:=num||to_char(lowerl);
if i=3 then upperl:=5;
end if;
end loop;
message(num);
end;
some changes in the programme.......
it will result 111

Is This Answer Correct ?

13 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to create an array in pl/sql?

1053

What are primary key and foreign key and how they work?

961

What is auto increment?

974

Why sql query is slow?

974

how to check myisam tables for errors? : Sql dba

1305

What is a column in a table?

1106

What are operators available in sql?

1024

What is sql data?

974

What are the different tcl commands in sql?

1151

What is a temporal data type?

1027

What is difference between stored procedures and application procedures?

995

Why is normalization important?

1009

What are predefined functions in sql?

1023

What is the use of & in pl sql?

1031

What is difference between sql and excel?

1070