Select Length('ram charan singh') - length(replace('ram ch

Give SQL Query to find the number words in a sentence ?
ex: 'ram charan singh' then ans:3
Answer:select length(trim('ram charan singh')) - length
(replace
(trim ( 'ram charan singh'),' ','')) +1 from dual

The above query working properly when space between the
words is only one &similar
But ,If the space between the words is nonuniform.
Ex:'ram charan singh is good' ans:5
i am not getting this answer using above query.

Question Posted / devraj

3 Answers
6993 Views
I also Faced
E-Mail Answers

Answer Posted / devraj

Select Length('ram charan singh') - length(replace('ram
charan singh', ' ','')) from dual;

Is This Answer Correct ?

1 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

List the types of joins used in writing subqueries?

981

How to use group functions in the select clause using oracle?

1053

How to create a stored procedure in oracle?

1079

What is recovery manager(rman) backup in Oracle?

1172

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1327

How to export your own schema?

995

What is the relation of a user account and a schema?

1107

What are the uses of linked server and explain it in detail?

1043

How to drop an index in oracle?

1053

How to write text literals in oracle?

1059

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1850

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2262

What is merge statement used for?

1005

How to define a record variable to store a table row?

1041

How to filter out duplications in the returning rows using oracle?

1006