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
- 9003 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
Why primary key is required?
How many databases can sql express handle?
Explain cursor types?
Can you join views in sql?
Why schema is used in sql?
Why do we go for stored procedures?
how to include character strings in sql statements? : Sql dba
what is “go” in t-sql? : Transact sql
how many triggers are allowed in mysql table? : Sql dba
what is the functionality of the function htmlentities? : Sql dba
How do you write an inner join query?
What are schema-level triggers?
How to avoid duplicate records in a query?
explain normalization concept? : Sql dba
what is the difference between $message and $$message? : Sql dba
