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 dump a table to a file with 'mysqldump'? : Sql dba

981

What is #table in sql?

995

what are null values? : Sql dba

899

How does postgresql compare to mysql?

987

What is normalisation and its types?

955

What is pl sql architecture?

921

What is the most common sql injection tool?

994

What are packages in pl sql and also explain its advantages?

959

Can we update views in sql?

897

What is cursor and why it is required?

1105

When can we use the where clause and the having clause?

966

What is mutating error?

907

How to fix oracle error ora-00942: table or view does not exist

955

Why functions are used in sql?

927

What are sql constraints?

1124