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 sharding in sql?

566

What are the subsets of sql?

551

Does sql require a server?

532

Why is partition used in sql?

550

What is sequence in sql?

506

What is user defined functions?

580

What does plv msg allows you to do?

681

Explain about various levels of constraint.

525

Explain what is sql?

610

Differentiate pl/sql and sql?

565

What is a pl/sql block?

595

How do you use a while loop in pl sql?

539

how is exception handling handled in mysql? : Sql dba

553

Which are the different character-manipulation functions in sql?

550

How to move files from one directory to another in pl sql?

642