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

Is sql port 1433 encrypted?

978

What is an ndf file?

941

Can pl sql procedure have a return statement?

970

What is the use of index in hive?

978

What is sequence in sql?

961

what is top in tsql? : Transact sql

1043

What is the difference between an inner join and an outer join?

988

What is a table?

970

Is sql a oracle?

926

Is foreign key mandatory?

960

what is collation? : Sql dba

1095

What are hotfixes and patches?

903

What is attribute indicator in pl sql?

980

What is the difference between microsoft access and sql?

978

Why use subqueries instead of joins?

1045