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


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

Answers were Sorted based on User's Feedback



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

Answer / bhakti

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

Is This Answer Correct ?    19 Yes 3 No

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

Answer / sanjaya

select regexp_count('RAM CHARAN SINGH','s')+1 from dual;

Is This Answer Correct ?    0 Yes 0 No

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

Answer / joel

select count('ram charan singh') dual;

Is This Answer Correct ?    2 Yes 22 No

Post New Answer

More Oracle General Interview Questions

How to get a list of all tables in the database?

1 Answers  


What are the different types of modules in oracle forms?

0 Answers  


does the query needs a hint to access a materialized view?

1 Answers  


What is the difference between an Oracle Schema and an Oracle Instance?

3 Answers   IBM,


Without giving condition how to retrieve the unmatched records from table.

1 Answers   TCS,


How to use existing values in update statements using oracle?

0 Answers  


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

0 Answers  


I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance

0 Answers   Cisco,


What is the difference between primary key and unique key and foreign key in oracle?

0 Answers  


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers  


How to retrieve first and last records from a table?

7 Answers   DELL, QSmart,


src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

0 Answers   IBM,


Categories
  • Oracle General Interview Questions Oracle General (1809)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)