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
- 8896 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
when is the use of update_statistics command? : Sql dba
Can we write ddl statements in functions?
What is varchar data type in sql?
What is the meaning of disabling a trigger?
What do you mean by query optimization?
What is triggering circuit?
What is the requirement of self-join?
Which are the different case manipulation functions in sql?
What has stored procedures in sql and how we can use it?
What is %type in sql?
What is the file extension for sql database?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What found sql?
Can procedure in package be overloaded?
Does pl sql work in mysql?
