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 are the advantages of normalization?
how to drop an existing index in mysql? : Sql dba
How many primary keys can a table have?
What is embedded sql with example?
How to display the current date in sql?
What is vector point function?
What is the maximum number of triggers, you can apply on a single table?
When is the explicit cursor used ?
what is self join and what is the requirement of self join? : Sql dba
Write the alter statement to enable all the triggers on the t.students table.
What are database links used for?
What is a variable in sql?
What is a primary key sql?
What is the difference between jpql and sql?
What does the hierarchical profiler does?