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 flashback in Oracle?

583

What is sharded cluster?

521

How to use an explicit cursor without open statements?

616

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1741

Explain integrity constraints?

672

What is ADDM Advisor in Oracle?

668

What is an oracle and why it is used?

627

Can a formula column referred to columns in higher group ?

2089

What is the best way to do multi-row insert in oracle?

567

What is the maximum limit on the number of columns in a table?

553

hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards

1567

Can the query output be sorted by multiple columns in oracle?

574

What happens to the current transaction if the session is killed?

536

List out the difference between commit, rollback, and savepoint?

622

How to enter a new row into a table interactively?

552