if a string is there like s1,s2,s3,s4.How to find count of
commas in this.
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
what is blob? : Sql dba
Is a secondary key the same as a foreign key?
What is dynamic sql in pl sql?
What is meant by truncate in sql?
Is sql port 1433 encrypted?
How do you define a foreign key?
How can I see all tables in sql?
What is oracle and pl sql?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
What is cartesian join in sql?
Explain the advantages and disadvantages of stored procedure?
What are the subsets of sql?
Where is all the data on the internet stored?
What are the types of functions in sql?
Does view contain data?