select regexp_count('RAM CHARAN SINGH','s')+1 from dual

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

Question Posted / sanjaya

Answer Posted / sanjaya

select regexp_count('RAM CHARAN SINGH','s')+1 from dual;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is index-organized table in Oracle?

657

What is set operator oracle?

612

How to start your 10g xe server?

683

How to convert times to characters in oracle?

685

What is oracle join syntax?

639

What is an oracle?

657

What is a server parameter file in oracle?

672

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

1855

Which environment variables are absolutely critical in order to run the OUI?

1746

Explain what are clusters?

716

Explain oracle’s system global area (sga).

702

What is the maximum number of triggers that can be applied to a single table?

650

Is a rollback possible to any savepoint?

636

Explain self joins in oracle?

653

How to get the Installed Oracle Version Information ?

723