if a string is there like s1,s2,s3,s4.How to find count of
commas in this.
Answer Posted / 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 |
Post New Answer View All Answers
What is dense_rank?
Why we use triggers in mysql?
How to fix oracle error ora-00942: table or view does not exist
What are string functions in sql?
What are different types of triggers?
what is not null constraint? : Sql dba
Why plvtab is considered as the easiest way to access the pl/sql table?
Explain the methods used to protect source code of pl/sql.
How to test for null values?
What is difference between db2 and sql?
What is #table in sql?
What is clustered and nonclustered index in sql?
What is the difference between function and procedure in pl/sql?
What is a join query?
What are the two types of exceptions in pl/sql?