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 ?
- 3 Answers
- 7759 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
What is int identity in sql?
What is record variable?
i have some prob lem to tell me about my self in interview first round ...
What is a loop in sql?
where are cookies actually stored on the hard disk? : Sql dba
What is a sql trace file?
What is schema in sql example?
How do I partition in sql?
tell me about various levels of constraint. : Sql dba
What is embedded sql what are its advantages?
How do you declare a constant?
What are the two parts of design view?
What are triggers in sql?
How do I save a stored procedure?
What is difference between hql and sql?
