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 >> Oracle >> Oracle General
  2. Suggest New Category

Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3

Question Posted / bhakti

Answer Posted / bhakti

select length(trim('ram charan singh')) - length (replace
(trim ( 'ram charan singh'),' ','')) +1 from dual

Is This Answer Correct ?    19 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2332

what is the difference between functional dependecy and multilevel dependency?

2422

What are the ansi data types supported in oracle?

898

What is the difference between formal parameters and actual parameters?

1006

Is there any function in oracle similar like group_concat of mysql?

989

How different is ms access and oracle?

990

How to unlock the sample user account in oracle?

919

What is background process in Oracle?

1052

Can you have more than one content canvas view attached with a window ?

2264

How to execute the package in oracle?

1039

How to drop a stored function?

1085

How many types of tables supported by oracle?

1020

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1873

How to sort the query output in oracle?

970

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2262