select length(trim('ram charan singh'))

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

Question Posted / bhakti

Answer Posted / bhakti

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

Is This Answer Correct ?

19 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How to connect to a remote server?

1127

How to define an explicit cursor in oracle?

1040

What is where clause in oracle?

1031

What types of joins are used in writing subqueries?

985

What privilege is needed for a user to delete rows from tables in another schema?

1070

Difference between cartesian join and cross join?

1047

What is bulk load in oracle?

1070

What are the numeric comparison operations?

1116

How to see free space of each tablespace?

1036

What are the uses of Database Trigger ?

1720

Is java required for oracle client?

1001

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1934

What are the attributes of the cursor?

1004

What are oracle functions?

1031

What is null value in oracle?

1097