select length('s1,s2,s3,s4')-length(replace('s1,s2,s3,s4�

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

Question Posted / debbie

Answer Posted / debbie

select
length('s1,s2,s3,s4')-length(replace('s1,s2,s3,s4',',')) as
Count_comma from dual

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How is data stored in sql?

1043

What is offset in sql query?

1095

What are the key differences between SQL and PL SQL?

1202

How many subqueries can be nested in a statement?

974

How many sectors are in a partition?

1064

how to shutdown mysql server? : Sql dba

1084

What is mdf ldf and ndf?

980

How do I use google cloud in sql?

1070

Is stored procedure faster than query?

953

What is the difference between sql and t sql?

1014

tell me about various levels of constraint. : Sql dba

1027

Is join and inner join the same?

991

Which normal form is best?

940

What are its different types of dbms?

990

What are sql commands?

993