select 's1,s2,s3,s4' str, length('s1,s2,s3,s4')

if a string is there like s1,s2,s3,s4.How to find count of
commas in this.

Question Posted / ajit

Answer Posted / ajit

select 's1,s2,s3,s4' str,
length('s1,s2,s3,s4') - length(replace('s1,s2,s3,s4', ',')) str2
from dual;

Is This Answer Correct ?

11 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is rename in sql?

972

When is a declare statement required?

1138

Why cross join is used?

1076

how do you login to mysql using unix shell? : Sql dba

1080

Does view contain data?

1033

What is the primary key?

952

what is innodb? : Sql dba

1105

What are the main features of cursor?

1071

What is cursor status?

1186

What does stand for in sql?

966

How do you optimize a query?

998

What is the difference between a database and a relational database?

1103

What is a natural join sql?

972

What is the difference between sql and mysql?

1117

In a distributed database system, can we execute two queries simultaneously?

1092