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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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 ?

Question Posted / guest

Answers were Sorted based on User's Feedback



declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into l..

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

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into l..

Answer / guest

result will be 111

Is This Answer Correct ?    6 Yes 0 No

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into l..

Answer / kotesh

result is 11111

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SQL PLSQL Interview Questions

How insert into statements in sql?

0 Answers  

What is dcl in sql?

0 Answers  

Why do we use procedures in pl sql?

0 Answers  

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

0 Answers  

What does a pl/sql package consist of?

0 Answers  

What is cursor explain with example?

0 Answers  

How we can update the view?

0 Answers  

What is the purpose of the sql select top clause?

0 Answers  

What is the difference between python and sql?

0 Answers  

How do you write an index?

0 Answers  

What jobs use sql?

0 Answers  

How can a function retun more than one value in oracle with proper example?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories