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 is time based sql injection?

963

What is the primary use of normalization?

1011

What is information schema in sql?

1078

What is a pdo connection?

1050

What is procedure explain with program?

1026

What is delete command in sql?

1121

What are the commands used in sql?

1085

What is the usage of sql functions?

1150

Is record in pl sql?

980

What is rowtype?

1027

What is difference between stored procedures and application procedures?

1022

what is commit? : Sql dba

1083

What are the benefits of triggers?

1175

how mysql optimizes distinct? : Sql dba

1083

Is primary key always clustered index?

1028