Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8940 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 auto increment?
how to convert character strings to numeric values? : Sql dba
What is the difference between subquery and correlated query?
What is rowid in sql?
How many types of cursors supported in pl/sql?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
What are the advantages of stored procedure?
Is a view faster than a stored procedure?
What are operators available in sql?
What is the best free sql database?
How do you add a column to a table?
Which is better trigger or stored procedure?
How many sql core licenses do I need?
What are the different ddl commands in sql?
What is asqueryable?
