Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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 ?

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

How do I run a pl sql procedure in sql developer?

916


What is difference between stored procedure and trigger?

1061


What are the different operators available in sql?

963


Can we use joins in subquery?

1089


how do you tune the slow running queries in oracle db , explain the methodology

2073


What is an ndf file?

927


When is the update_statistics command used?

1049


What port does sql server use?

989


When is the explicit cursor used ?

982


Why is partition used in sql?

1051


What is the trigger in sql?

905


What is difference between db2 and sql?

940


What is normalisation in sql?

1005


What is bind reference and how can it be created?

968


How does a covering index work?

907