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
- 9075 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
What does truncate mean in sql?
what are the different type of sql's statements ? : Sql dba
How do you update f as m and m as f from the below table testtable?
How will you distinguish a global variable with a local variable in pl/sql?
what are the differences between binary and varbinary? : Sql dba
how would concatenate strings in mysql? : Sql dba
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
Do we need to rebuild index after truncate?
What is database sql?
Can delete statement be rollbacked?
what are rollup and cube in t-sql? : Transact sql
How can we make an if statement within a select statement?
what are wild cards used in database for pattern matching ? : Sql dba
Should I use mbr or gpt?
What is the trigger in sql?
