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

What is auto increment in sql?

1180

How many types of sql are there?

1047

How do you optimize a query?

1060

What are three advantages to using sql?

1071

Write the alter statement to enable all the triggers on the t.students table.

1175

Explain spool.

1219

what is the difference between join and union? : Sql dba

1203

What are keys in sql?

1042

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

1117

Write a sql select query that only returns each name only once from a table?

1077

What does subquery mean in sql?

1114

Is sql microsoft?

1108

Can we insert data into materialized view?

993

What are the possible values for the boolean data field?

1016

What is scope of pl sql developer in future?

1072