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

How to Execute a Package in PL/SQL.?

1218

what is the difference between delete and truncate statement in sql? : Sql dba

1258

What are primary key and foreign key and how they work?

983

Why is theta join required?

1152

When should I use nosql database?

1021

Differentiate pl/sql and sql?

1071

Explain architecture of sql server notification services?

1070

What is pl sql block structure?

1047

how many values can the set function of mysql take? : Sql dba

998

How can triggers be used for the table auditing?

1079

What are all the different types of indexes?

1159

How can use stored procedures in sql?

1149

What is mdb stand for?

1018

Explain what is sql*plus?

1154

What are the set operators in sql?

1087