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 ?
Answers were Sorted based on User's Feedback
Answer / 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 |
What is the use of sqlerrd 3?
Is sqlite thread safe?
what is inline view?
what is the syntax used for partition in tsql? : Transact sql
How to use transactions efficiently : transact sql
What are Anti joins
How do you change a value in sql?
how to create a new table by selecting rows from another table in mysql? : Sql dba
is it mandatory to select all the column in a view then what columns should be selected
Can I learn sql in a week?
Why is partition used in sql?
what are the advantages of package?