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 the different types of functions in sql?

995

What is localdb mssqllocaldb?

1015

Is a foreign key always unique?

882

What is Histogram?

1500

What is scalar data type in pl sql?

1018

What are all the different types of indexes?

1090

How can we solve sql error: ora-00904: invalid identifier?

1161

What is autocommit sql?

922

What view means?

927

What is the usage of the distinct keyword?

1162

what are sequences

1598

What is an inner join sql?

952

What is cross join sql?

862

which types of join is used in sql widely? : Sql dba

928

What is a pragma statement?

1200