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 the difference between a primary key & a unique key?

1092

What is a cognitive schema?

978

How to call a sub procedure?

1101

How to define an explicit cursor in oracle?

1045

How to convert characters to times in oracle?

1023

Explain the use of compress option in exp command.

1021

How to define a specific record type?

1088

Describe varray?

1064

How to name query output columns in oracle?

1190

How to define an oracle cursor variable?

1034

What is instant client oracle?

1027

Which are the five query types available in oracle?

953

What is bulk collect in oracle?

999

What are the differences between primary key and unique key?

1013

How to define an external table with a text file?

1075