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 tables in sql?

1041

What is normalization? How many normalization forms are there?

1066

What is the starting oracle error number?

1036

What are the uses of sysdate and user keywords?

1085

How do you rename a table in sql?

1084

give the syntax of grant and revoke commands? : Sql dba

1137

how to create a new view in mysql? : Sql dba

924

What is bulk collect in pl sql?

1074

Why we use join in sql?

944

What is form and report?

960

What are sql*plus environment variables?

1075

how to get @@error and @@rowcount at the same time? : Sql dba

1009

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1035

How to find 3rd highest salary of an employee from the employee table in sql?

1060

What are field types?

977