Interested to Buy Any Domain ? << Click Here >> for more details...
if a string is there like s1,s2,s3,s4.How to find count of
commas in this.
- 4 Answers
- 8834 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
Is pl sql useful?
What will you get by the cursor attribute sql%found?
How does sql*loader handles newline characters in a record? : aql loader
What is dynamic query?
What is rtm stands for?
What is the difference between partition and index?
What are dml commands?
What is difference between my sql and sql?
how to shutdown mysql server? : Sql dba
What is meant by user defined function?
What is difference between stored procedure and trigger?
Explain 3 basic parts of a trigger.
What are all the different types of indexes?
Is big data nosql?
how to create a table index in mysql? : Sql dba
