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

How to assign a tablespace to a users in oracle?

1089

Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?

2042

What is an oracle transaction?

1229

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2251

What is a read only transaction in oracle?

1080

Explain the features of oracle?

1109

How do you tell what your machine name is and what is its IP address?

2156

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

2091

How to create a new oracle data file?

1076

What is user managed backup in Oracle?

1206

How to invoke the data pump import utility?

1229

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2373

What are the different types of trigger and explain its various uses and functions?

1169

How do you bind variables in oracle?

1024

Explain what are the uses of rollback segment?

1068