if a string is there like s1,s2,s3,s4.How to find count of commas in this.

if a string is there like s1,s2,s3,s4.How to find count of
commas in this.

Question Posted / shah.sonal2988

4 Answers
7728 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if a string is there like s1,s2,s3,s4.How to find count of commas in this...

Answer / ajit

select 's1,s2,s3,s4' str,
length('s1,s2,s3,s4') - length(replace('s1,s2,s3,s4', ',')) str2
from dual;

Is This Answer Correct ?

11 Yes

1 No

if a string is there like s1,s2,s3,s4.How to find count of commas in this...

Answer / prashant

14:41:23 SQL> SELECT regexp_count ('s1,s2,s3,s4', ',')
14:41:24 2 FROM DUAL;

REGEXP_COUNT('S1,S2,S3,S4',',')
-------------------------------
3

Elapsed: 00:00:00.00
14:41:26 SQL>

Is This Answer Correct ?

9 Yes

2 No

if a string is there like s1,s2,s3,s4.How to find count of commas in this...

Answer / debbie

select
length('s1,s2,s3,s4')-length(replace('s1,s2,s3,s4',',')) as
Count_comma from dual

Is This Answer Correct ?

1 Yes

0 No

if a string is there like s1,s2,s3,s4.How to find count of commas in this...

Answer / ashok

SELECT LENGTH(REGEXP_REPLACE('s1,s2,s3,s4', '[s0-9]', '')) FROM dual

Is This Answer Correct ?

1 Yes

0 No

Post New Answer