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

Can we call dml statement in function?

994

What is the source code of a program?

1021

Does google use sql?

921

Explain mutating table error.

1151

What is sql rowcount?

964

How does one load ebcdic data? : aql loader

1116

What are the disadvantages of file system?

1192

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

925

What does plv msg allows you to do?

1091

Is postgresql a server?

1011

Can delete statement be rollbacked?

948

Can we use loop in sql?

942

Which type of cursor is used to execute the dml statement?

909

What is sqlerrm?

890

Can you rollback after commit?

949