SELECT LENGTH(REGEXP_REPLACE('s1,s2,s3,s4', '[s0-9]', &

if a string is there like s1,s2,s3,s4.How to find count of
commas in this.

Question Posted / ashok

Answer Posted / ashok

SELECT LENGTH(REGEXP_REPLACE('s1,s2,s3,s4', '[s0-9]', '')) FROM dual

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are system versioned tables?

1075

What is compound trigger?

1106

how to convert character strings to dates? : Sql dba

1102

How to read/write files from pl/sql?

1085

Which nosql database is best?

1025

What is the difference between partition and index?

1062

What are character functions?

1141

what is sql server agent? : Sql dba

1158

what is cursor. write example of it. What are the attributes of cursor.

1467

What does a pl/sql package consist of?

1019

Cite the differences between execution of triggers and stored procedures?

1139

explain the delete statements in sql

1137

What are views in sql?

1037

How to download oracle sql developer?

1167

what are the limitations of identity column? : Transact sql

1163