14:41:23 SQL> SELECT regexp_count ('s1,s2,s3,s4', ','

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

Question Posted / prashant

4 Answers
9191 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Is stored procedure faster than query?

1022

What view means?

1025

Is sql a case sensitive language?

1010

What is a table in a database?

1096

Explain character-manipulation functions?

1176

What is the difference between row level and statement level trigger?

1072

Is left join faster than join?

1096

Is drop table faster than truncate?

1051

What are two statement types in sql?

1161

Enlist the characteristics of pl/sql?

1847

What is the use of sqldataadapter?

1027

What is the difference between sql and t sql?

1107

Can instead of triggers be used to fire once for each statement on a view?

1007

Is it possible for a table to have more than one foreign key?

1084

What is t-sql? : Transact sql

1042