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 ?
Answer Posted / kotesh
result is 11111
Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Where is sql database stored?
What are different types of statements supported by sql?
what is oltp (online transaction processing)? : Sql dba
What is structural independence and why is it important?
Why do we use sql constraints? Which constraints we can use while creating database in sql?
what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba
What is sql comments?
How to avoid duplicate records in a query?
What is a subquery in sql?
What is synchronized subquery?
Which join is default?
Is drop table faster than truncate?
How do I run a pl sql procedure in sql developer?
How do I turn a list into a table?
what is a composite primary key ? : Sql dba