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


Please Help Members By Posting Answers For Below Questions

What is normalization in sql?

519


How many sql are there?

505


What is the main difference between sql and pl/sql?

558


i have some prob lem to tell me about my self in interview first round ...

1695


How many indexes can be created on a table in sql?

490






What is query execution plan in sql?

558


what is data manipulation language? : Sql dba

525


Why is partition used in sql?

541


what is isam? : Sql dba

568


Can pl sql procedure have a return statement?

546


What is a call statement? Explain with an example.

541


What is raw datatype in sql?

546


How can I change database name in sql?

521


How to write a query to show the details of a student from students table whose

535


Is there a 64 bit version of ssms?

509