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 is the maximum size of sqlite database?
what does the t-sql command ident_incr does? : Transact sql
what is the difference between where clause and having clause? : Sql dba
How to run sql functions in pl/sql?
Cite the differences between execution of triggers and stored procedures?
What is record in pl sql?
What is synonyms?
What is materialized view. What are different methods of refresh?
Which language is used in sql?
What are the subsets of sql?
How to raise user-defined exception with custom sqlerrm ?
Can we insert data into view?
Does group by remove duplicates?
What is equi join in sql?
what is oracle database ? : Sql dba