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

How to pass parameters to procedures in oracle?

1011

Explain the use of owner option in exp command.

1007

What are the built-in functions used for sending Parameters to forms ?

3332

What does sharding mean?

961

HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE

2201

Explain an extent?

1059

How to find the duplicate rows count from employees table in oracle?

1055

How can I combine multiple rows into a comma-delimited list in oracle?

1015

How to use windows user to connect to the server?

956

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

2281

How to convert a date to char in oracle? Give one example.

1015

What is bulk copy or bcp in oracle?

1076

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

1007

what are archived logs?

2159

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4486