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 difference between nchar and nvarchar?

955

How can triggers be used for the table auditing?

1008

Explain what is sql*plus?

1084

How to get help at the sql prompt?

1052

Why stored procedures are faster than query?

968

Do ddl statements need commit?

921

what does myisamchk do? : Sql dba

961

What are the different types of database management systems?

949

What information is needed to connect sql*plus an oracle server?

977

What is a full join sql?

980

what is a join? : Sql dba

960

How to assign sql query results to pl sql variables?

991

What is sql key?

917

What is delimiter sql?

920

What is user in sql?

966