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

Which is better Oracle or MS SQL? Why?

5029

Explain the use of parfile option in exp command.

1138

How to update a table row with a record?

1065

How can we create the complete backup of data in the oracle.

2199

How to see free space of each tablespace?

1081

what is dynamic SGA and static SGA

4485

What do you mean by a database transaction & what all tcl statements are available in oracle?

1036

What is archive log in Oracle?

1182

What is raw datatype in oracle?

1207

How to import one table back from a dump file?

1081

What are the different pseudo commands? Explain in general?

1123

What is a view and how is it different from a table?

1125

What is literal?

1062

How to call a stored function with parameters?

1092

what are bitmap indexes? How does they work?

2302