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 is difference sql and mysql?

977

What is left join example?

942

Is there a 64 bit version of ssms?

956

what are null values? : Sql dba

951

What is sql in oracle?

1057

What are the possible values for the boolean data field?

959

How to install oracle sql developer?

1042

what are sequences

1741

What are views in sql?

975

how to use 'mysql' to run sql statements? : Sql dba

1051

Is sql a backend language?

1090

what is a stored procedure? : Sql dba

1125

What are the two types of periodical indexes?

936

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

950

What are properties of the transaction?

997