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

count the numbers between 100 and 300, that star
with 2 and ends with 2

Answer Posted / sushma s

PL\SQL Code:

Declare
n number(10) := 0;
begin
for i in 100 .. 300
loop
if (substr(i,1,1) =2) and (substr(i,length(i),1) = 2) then
n := n +1;
dbms_output.put_line('number :'|| i ||' count:' ||n);
end if;
end loop;

end;

O/P: count: 10

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an operator?

1018


What do you mean by dynamic memory allocation in c?

1050


is it possible to create your own header files?

1045


What is nested structure with example?

1012


i = 25;switch (i) {case 25: printf("The value is 25 ");case 30: printf("The value is 30 "); When the above statements are executed the output will be : a) The value is 25 b) The value is 30 c) The value is 25 The value is 30 d) none

1010


A collection of functions,calls,subroutines or other data a) library b) header files c) set of files d) textfiles

1119


What does a function declared as pascal do differently?

1040


Why malloc is faster than calloc?

1014


What is const volatile variable in c?

982


what is the diffrenet bettwen HTTP and internet protocol

1786


What are linked lists in c?

1086


Can we replace the struct function in tree syntax with a union?

1238


Tell me with an example the self-referential structure?

941


Explain what are preprocessor directives?

1015


What does the error message "DGROUP exceeds 64K" mean?

1168