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
- 7772 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
How many subqueries can be nested in a statement?
What is auto increment in sql?
difference between anonymous blocks and sub-programs.
What are sql*plus environment variables?
What are the ddl commands?
what is a trigger? : Sql dba
What is sql catalog?
what are the differences among rownum, rank and dense_rank? : Sql dba
What is the use of sqldataadapter?
What is dbo in sql?
Explain the methods used to protect source code of pl/sql.
What is a sql instance vs database?
What is the importance of sqlcode and sqlerrm?
What is nested table in pl sql?
What are pl/sql cursors?
