Try This in 10g SELECT length(REGEXP

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 / murali mohan

3 Answers
7177 Views
I also Faced
E-Mail Answers

Answer Posted / murali mohan

Try This in 10g

SELECT length(REGEXP_REPLACE('ram charan
singh is good',
'( ){2,}', ' ')) - length(replace (trim ( 'ram
charan singh is good'),' ','')) +1
AS RX_REPLACE
FROM dual;

Regards,
Murali

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain alias?

1188

How to drop a stored function?

1180

What are the restrictions in a oracle read only transaction?

1077

What are the various constraints used in oracle?

1089

How many memory layers are in the oracle shared pool?

1248

How translate command is different from replace?

1135

What is bulk load in oracle?

1120

State some uses of redo log files?

1064

How would you begin to troubleshoot an ORA-3113 error?

2121

Can select statements be used on views in oracle?

1082

What is the exact use of Collections?

2187

Explain a segment?

1124

How to list all indexes in your schema?

1138

How to change program global area (pga) in oracle?

1144

What is a read write transaction in oracle?

1126