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

counting the no.of characters occurs in a string by using
pl/sql function

Question Posted / suresh


counting the no.of characters occurs in a string by using pl/sql function..

Answer / revathy

create or replace function f1(
iip in varchar2,iip2 in char)
Return number
is
tot number;
Begin
select (length(iip)-length(replace(iip,iip2))) into tot
from dual;
return tot;
end;

Is This Answer Correct ?    14 Yes 1 No

Post New Answer

More SQL PLSQL Interview Questions

What is a CTE (Common Table Expression), and how is it different from a subquery?

3 Answers  

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

Is it possible to create startup or shutdown trigger for on-schema?

0 Answers  

What is the result, when NULL is compared with NULL?

22 Answers   TCS,

what is definer rights invoke rights?

1 Answers  

What is Referential Integrity?

3 Answers   IBM,

Is ms sql traffic encrypted?

0 Answers  

What is a dynamic query?

0 Answers  

What is query optimization in sql?

0 Answers  

What is the criteria while applying index to any column on any table.

1 Answers   Infogain,

What are types of joins?

0 Answers  

What is posting?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories