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 the syntax for using sql_variant_property? : Transact sql

1055

What do you understand by pl/sql cursors?

1095

What is ttitle and btitle?

1070

What is the meaning of disabling a trigger?

1186

What are the benefits of triggers?

1176

What is difference between nchar and nvarchar?

1037

What does subquery mean in sql?

1060

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1002

What does varchar include?

955

What is difference between stored procedure and trigger?

1178

How do you get column names only for a table (sql server)?

1174

Which command is used to delete a trigger?

1339

What is sql integrity?

1165

What is sql trigger example?

1074

How to start oracle sql developer?

1049