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
How do I run a pl sql procedure in sql developer?
What is difference between stored procedure and trigger?
What are the different operators available in sql?
Can we use joins in subquery?
how do you tune the slow running queries in oracle db , explain the methodology
What is an ndf file?
When is the update_statistics command used?
What port does sql server use?
When is the explicit cursor used ?
Why is partition used in sql?
What is the trigger in sql?
What is difference between db2 and sql?
What is normalisation in sql?
What is bind reference and how can it be created?
How does a covering index work?