select 's1,s2,s3,s4' str, length('s1,s2,s3,s4')

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

Question Posted / ajit

Answer Posted / ajit

select 's1,s2,s3,s4' str,
length('s1,s2,s3,s4') - length(replace('s1,s2,s3,s4', ',')) str2
from dual;

Is This Answer Correct ?

11 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are different types of indexes?

1058

What is difference between group by and partition by?

1129

How do you break a loop in pl sql?

1103

Does mysql_real_escape_string prevent sql injection?

995

What is native sql query?

1076

How do I run a sql trace?

1004

Can we use ddl statements in stored procedure?

1193

Can we delete column in sql?

1176

Is it possible to link two groups inside a cross products after the cross products group has been created?

1073

Can we use pl sql in mysql?

1063

what tools available for managing mysql server? : Sql dba

1133

Is sql similar to python?

1043

what are tables and fields? : Sql dba

1105

How does join work in sql?

1054

How do you use collections in procedure to return the resultset?

2286