if a string is there like s1,s2,s3,s4.How to find count of
commas in this.
Answers were Sorted based on User's Feedback
Answer / ajit
select 's1,s2,s3,s4' str,
length('s1,s2,s3,s4') - length(replace('s1,s2,s3,s4', ',')) str2
from dual;
Is This Answer Correct ? | 11 Yes | 1 No |
Answer / 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 |
Answer / debbie
select
length('s1,s2,s3,s4')-length(replace('s1,s2,s3,s4',',')) as
Count_comma from dual
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ashok
SELECT LENGTH(REGEXP_REPLACE('s1,s2,s3,s4', '[s0-9]', '')) FROM dual
Is This Answer Correct ? | 1 Yes | 0 No |
What is secondary key?
What are different clauses used in sql?
What is a database? Explain
Give an example of any procedure.
5 Answers Accenture, iFlex, Wipro,
What is sqlcommand?
what is 'mysqldump'? : Sql dba
What is the difference between stored procedure and view?
what is sql optimization
What does 0 mean in sql?
Explain the significance of the & and && operators in pl sql.
What is primary key and unique key?
Why should I use postgresql?