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 triggers and its uses?

1047

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3570

What is rank function in sql?

1029

What is clause in sql?

1109

What is pivot table in sql?

1108

what are properties of a transaction? : Sql dba

1094

What is trigger in sql? Explain

997

What is the use of & in pl sql?

1046

how can we know the number of days between two given dates using mysql? : Sql dba

1048

Why we use joins in sql?

984

Does varchar need length?

995

What is the difference between execution of triggers and stored procedures?

1116

what is error ora-03113: end-of-file on communication channel?

1165

What is use of package in pl sql?

1015

What are the uses of sysdate and user keywords?

1105