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

Is primary key a clustered index?

710

Explain the insert into statements in sql?

740

What are the benefits of stored procedures?

726

What is difference between ms sql and mysql?

672

Which is faster view or stored procedure?

699

How can I tell if sql is running?

775

What is difference between stored procedures and application procedures?

770

what are the different functions in sorting an array? : Sql dba

773

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

828

What is the benefit of foreign key?

726

how many columns can be used for creating index? : Sql dba

681

Can we alter stored procedure?

728

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

724

Is primary key always clustered index?

739

What is meant by truncate in sql?

763