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
8912 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

what is blob? : Sql dba

1083

Is a secondary key the same as a foreign key?

974

What is dynamic sql in pl sql?

1000

What is meant by truncate in sql?

1024

Is sql port 1433 encrypted?

982

How do you define a foreign key?

955

How can I see all tables in sql?

1010

What is oracle and pl sql?

1096

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

934

What is cartesian join in sql?

1059

Explain the advantages and disadvantages of stored procedure?

1098

What are the subsets of sql?

1072

Where is all the data on the internet stored?

960

What are the types of functions in sql?

981

Does view contain data?

995