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 sql deadlock?

566

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

1529

What are the different types of joins in sql?

585

Are null values same as that of zero or a blank space?

533

How many databases can sql express handle?

536

How insert into statements in sql?

595

How do you update a value in sql?

549

What are pl sql data types?

551

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

549

what is a database transaction? : Sql dba

587

What is attribute indicator in pl sql?

526

How does postgresql compare to oracle/db2/ms sql server/informix?

570

Can a foreign key be null?

593

what are the advantages and disadvantages of cascading style sheets? : Sql dba

553

What plvcmt and plvrb does in pl/sql?

881