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
8770 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 do I pipe the output of one isql to another?

945

What is difference between my sql and sql?

997

What is join view in sql?

898

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

1178

How do I tune a sql query?

935

What is a system versioned table?

932

What is flag in sql?

984

How many types of cursors are available in pl/sql?

1045

How is data stored on a disk?

964

What is data modelling in sql?

964

Do ddl statements need commit?

925

What is the life of an sql statement?

964

Which is better stored procedure or query?

922

What is sql select statement?

971

Can there be 2 primary keys in a table?

952